ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protecting my macros from being viewed/edited? (https://www.excelbanter.com/excel-programming/308188-protecting-my-macros-being-viewed-edited.html)

No Name

Protecting my macros from being viewed/edited?
 
How can I protect my macros from being viewed/edited?
Thanks for the tips!

Tom Ogilvy

Protecting my macros from being viewed/edited?
 
In the VBE

first, rename your project from the default name VBAProject to a unique
name.

then make sure it is selected in the project explorer window so it is the
active project. Then if you go to the tools menu you will have an option

MyUniqueProjectName Properties . . .

under this selection is a tab for protecting the project. Click the lock
project for viewing and assign a password.

--
Regards,
Tom Ogilvy


wrote in message
...
How can I protect my macros from being viewed/edited?
Thanks for the tips!





All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com