Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel vba code

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

ResolvedVersion 2003

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?

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

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 courses

98.7 % recommend us

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Please browse our web site to find out more about
excel computer training and other training courses.

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.09 secs.