restict access to vba from worksheet

P

Paul B

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is to the left of the "File" menu this
will open the VBA editor, in the left hand window right click on your
workbook name and select VBA project properties, protection, check lock
project for viewing and set a password. Press Alt and Q to close this window
and go back to your workbook and save and close the file
Be aware that this password can be hacked with 3rd party software
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restrict from data to be copied to other distk 1
Restricting Internet Access 1
Print Macro Problem 2
Fixing the number of Col and rows. 1
Sharing 1
Restrict the Time value entered in a text box 1
Local Security Policy vs Deep freeze 2
routine to add a field to my tasks 1

Top