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
hasAsked:
Who is Participating?
 
frazerConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.