macro visibility

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

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Macro visibility

Macro visibility

resolvedResolved · Low Priority · Version 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:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips


Server loaded in 0.07 secs.