• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

password with .xla

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
has
Asked:
has
1 Solution
 
frazerCommented:
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
 
hasAuthor Commented:
great, thanks alot
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now