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

macro visibility

ResolvedVersion 2003

Kaajal has attended:
Excel VBA Intro Intermediate course

Macro visibility

Is there a way to hide macros from being seen by others so that they only see the results when they open the workbook? For example, by setting a password.

RE: Macro visibility

Hi Kaajal

Thank you for your question

You can indeed password project your code.

In the VBE click on Tools_VBA Project Properties

On the protection tab tick lock project for viewing and then set the required password below

Regards

Stephen

Tue 8 Sep 2009: Automatically marked as resolved.

 

Training courses

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

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

Access tip:

Add current time to a field

Press CTRL+SHIFT+ SEMICOLON

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.