Disable Macros through VBA

  • Thread starter Thread starter Mirom
  • Start date Start date
M

Mirom

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.
 
disabling/enabling the macro dialog isn't possible by design. you ca
only kludge your way around it with sendkeys and the like..
 
See one suggestion at your other post.

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.
Click to expand...
 
Dave Peterson said:
See one suggestion at your other post.
Click to expand...
Thank You very much for the answer.
I forget to specify that I am using Excel 2000. Sorry.
Regards. Mirom.
 
Back
Top