How to disable Macros in VBA code
 

In my code, I create an Excel Application object during runtime. Using the
same, I open an workbook which has macros attached to its Workbook_Open
event. Is there a way, I could disable the execution of the macros associated
with the Workbook.

Also, in case I try to open a readonly workbook through code, it asks for
confirmation whether the workbook should be opened as read only. Is there a
way, I could skip this confirmation.


regards

RoHiT

How to disable Macros in VBA code
 

just a guess, try:

Application.DisplayAlerts = False, for the second query, and it should work
for the first if your security setting is set to medium beforehand. If it is
low, the macros will be enabled directly without promting.

at the start.


Mangesh





"RoHiT" wrote in message
...
In my code, I create an Excel Application object during runtime. Using the
same, I open an workbook which has macros attached to its Workbook_Open
event. Is there a way, I could disable the execution of the macros
associated
with the Workbook.

Also, in case I try to open a readonly workbook through code, it asks for
confirmation whether the workbook should be opened as read only. Is there
a
way, I could skip this confirmation.


regards

RoHiT

How to disable Macros in VBA code
 

HI
Use :
Application.enableEvents=false
open the WB
Application.enableEvents=true
This way, any associate events will not be fired.
Regards
Jean-Yves

"RoHiT" wrote in message
...
In my code, I create an Excel Application object during runtime. Using the
same, I open an workbook which has macros attached to its Workbook_Open
event. Is there a way, I could disable the execution of the macros
associated
with the Workbook.

Also, in case I try to open a readonly workbook through code, it asks for
confirmation whether the workbook should be opened as read only. Is there
a
way, I could skip this confirmation.


regards

RoHiT

How to disable Macros in VBA code
 

How do I set the Macro Security to Low through VBA code.

"Mangesh Yadav" wrote:

just a guess, try:

Application.DisplayAlerts = False, for the second query, and it should work
for the first if your security setting is set to medium beforehand. If it is
low, the macros will be enabled directly without promting.

at the start.


Mangesh





"RoHiT" wrote in message
...
In my code, I create an Excel Application object during runtime. Using the
same, I open an workbook which has macros attached to its Workbook_Open
event. Is there a way, I could disable the execution of the macros
associated
with the Workbook.

Also, in case I try to open a readonly workbook through code, it asks for
confirmation whether the workbook should be opened as read only. Is there
a
way, I could skip this confirmation.


regards

RoHiT

How to disable Macros in VBA code
 

I doubt that's possible, otherwise the whole issue of having security will
be unjustified.

Mangesh



"RoHiT" wrote in message
...
How do I set the Macro Security to Low through VBA code.

"Mangesh Yadav" wrote:

just a guess, try:

Application.DisplayAlerts = False, for the second query, and it should
work
for the first if your security setting is set to medium beforehand. If
it is
low, the macros will be enabled directly without promting.

at the start.


Mangesh





"RoHiT" wrote in message
...
In my code, I create an Excel Application object during runtime. Using
the
same, I open an workbook which has macros attached to its
Workbook_Open
event. Is there a way, I could disable the execution of the macros
associated
with the Workbook.

Also, in case I try to open a readonly workbook through code, it asks
for
confirmation whether the workbook should be opened as read only. Is
there
a
way, I could skip this confirmation.


regards

RoHiT