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..

--
Message posted from http://www.ExcelForum.com

See one suggestion at your other post.


Mirom wrote:

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.

--

Dave Peterson

Dave Peterson wrote in message ...
See one suggestion at your other post.


Thank You very much for the answer.
I forget to specify that I am using Excel 2000. Sorry.
Regards. Mirom.