98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA - code protection from users
Excel VBA - code protection from users
Resolved · Low Priority · Version 2003
Fri 12 Feb 2010, 15:52Delegate George said...
George has attended:
Excel VBA Intro Intermediate course
Excel VBA - code protection from users
How can I protect the code written in VBA from the user accessing or modifying it?Are there any password controls?
Fri 12 Feb 2010, 17:02Delegate Sophie said...
RE: Excel VBA - code protection from users
Hi there
I think what you are looking for is
Open you VBE
Select your module
Right click VBA : project properties
Choose protection
Lock projection for viewing and add your password.
Hope this is what you needed
Wed 17 Feb 2010, 10:18Trainer Stephen said...
RE: Excel VBA - code protection from users
Hi George
Thanks for your question
I have little to add to Sophies response to your post, as this is the correct way to achieve that objective
Regards
Stephen
Tue 23 Feb 2010: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting constant values onlyIf periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter. |
