Solved

password with .xla

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Outlook Free & Paid Tools
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 video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

756 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