LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Disable Macros when opening workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable macros on a programmatically opening .xls file Matt[_2_] Excel Discussion (Misc queries) 2 May 25th 07 04:45 AM
Break/disable a macro when opening a workbook Niklas Excel Programming 4 June 30th 04 10:07 PM
Disable the opening of another workbook DDLY Excel Programming 1 November 26th 03 07:52 PM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM
Opening a workbook containing macros from VB Brian Walters Excel Programming 2 August 6th 03 10:20 PM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"