Solved

password with .xla

Posted on 1998-10-22
2
512 Views
Last Modified: 2011-08-18
I create an .xla file for my macro, when I save as
it I select options, and give password, (2, 2 for verification, 4 times) and exit. next time I start excel
I put this as add-in, but when I go to VBA, it shows
all my code. But other add-in s are protected, how do they
do it. I need to keep my .xla file protected all times.
thanks
0
Comment
Question by:has
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
frazer earned 100 total points
ID: 1614117
Hi,

If you right click on your project in the VBA project window and select properties, then choose the protection tab, click lock project for viewing and enter a password your project will remain locked.

Hope this helps

Frazer
0
 

Author Comment

by:has
ID: 1614118
great, thanks alot
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question