Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do i disable macros when opening a workbook in code?
I have a workbook that creates a new menu when it opens and destroys the menu when it closes. One of the choices in that menu is to open an older version of that same workbook and import its data and then close that workbook. When it closes, it destroys the wrong menu. How do i solve this problem? One way would be to disable macros on the workbook that is opened in code. Another would be to temporarily set macro security to high. Any other ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable macros on a programmatically opening .xls file | Excel Discussion (Misc queries) | |||
Break/disable a macro when opening a workbook | Excel Programming | |||
Disable the opening of another workbook | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Opening a workbook containing macros from VB | Excel Programming |