View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mirom Mirom is offline
external usenet poster
 
Posts: 4
Default Disable Macros through VBA

Is there any way to disable macros in the specific Workbook from VBA
code before opening that very same Workbook with VBA code i.e. to open
some workbook in "Disable Macros MODE" using only VBA. Or, to refrase
the question, how should be written in the VBA language, the event
when user manualy opens some workbook and when prompted for macro
virus protection, he clicks the "Disable Macros" buton. For which
"Object"(probably Workbook.VBProject) and what property (something
like "Enable Macros") has changed at that occasion.
Thank You in advance. Regards. Mirom.