Hiding macros

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

Guest

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
 
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
 
Back
Top