View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default enable/disable macro

You can disable code that run when you open the workbook by holding the
Shift key when you open the workbook in Excel.

Note: You can use the macro's only the code that run automatic when you open the workbook will not run

--
Regards Ron De Bruin
http://www.rondebruin.nl



"RICK" wrote in message ...
Is there anyway that the running of macros can be disabled while EXCEL is
OPEN. The only way that I have found to disable macros is to shut down
EXCEL, restart EXCEL, and select to disable the macros.

RICK