Hiding macros

W

Warren

I am trying to figure out how to hide macros (auto_open & auto_close) associated with a workbook. Currently, I have all sheets password protected and so is the workbook. When I open the workbook, I can still get to the macro and edit it. Instead I need to have them hidden

Any help is appreciated. Thanks in advance, Warren
 
G

Gord Dibben

Warren

Open Visual Basic Editor(ALT + F11)

With Project Explorer window open right-click on your workbook/project and
select VBAProject Proerties>Protection.

Lock for viewing with a password which you will write down and keep somewhere
safe.

Gord Dibben Excel MVP
 
Top