How to pretect editing the macros by other users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am in the process of writing macros and deploying in all the users of my office. I would like to protect (for that matter not able to see the macro code) the macros being editing / viewed by other users. Is there any way to password protect the macros

I would like to know the above for MS-Word, excel and Powerpoint

Thanks
K. Rajaseka
 
Hi

In the Visual Basic Editor, locate the name of your project in the
Project Explorer window. Right-click the name and choose Properties. On
the Protection tab, you can choose to lock the project for viewing, and
give it a password.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
Melbourne, Australia


K. Rajasekar said:
Hi,

I am in the process of writing macros and deploying in all the users
Click to expand...
of my office. I would like to protect (for that matter not able to see
the macro code) the macros being editing / viewed by other users. Is
there any way to password protect the macros?
 
Back
Top