Solved

password with .xla

Posted on 1998-10-22
2
507 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
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel - INDEX MATCH error 13 23
how to do this Excel search box Soundex Search 6 27
Excel 2007 VB Code for GCF 7 13
Index Match Formula VBA 6 13
This article will show you how to use shortcut menus in the Access run-time environment.
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

840 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