Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros?
Hi, I am programatically copying worksheets from one workbook to another.
The macros come with the worksheet, which I don't want to happen. I can't guaranteed the users will disable macros when opening the new workbook. How can I easily: 1. Copy only the worksheet, not the underlying code, or 2. insert code that disables macros on open, or 3. programmatically save the file so macros are disabled next time it's opened, or 4. manually save the file so that macros are disabled next time it's opened? 5. Do you have a simpler idea how to not copy, delete, or not execute code for a whole bunch of worksheets? Thank you, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros?
See if this fits the bill
http://www.cpearson.com/excel/vbe.htm -- HTH... Jim Thomlinson "me" wrote: Hi, I am programatically copying worksheets from one workbook to another. The macros come with the worksheet, which I don't want to happen. I can't guaranteed the users will disable macros when opening the new workbook. How can I easily: 1. Copy only the worksheet, not the underlying code, or 2. insert code that disables macros on open, or 3. programmatically save the file so macros are disabled next time it's opened, or 4. manually save the file so that macros are disabled next time it's opened? 5. Do you have a simpler idea how to not copy, delete, or not execute code for a whole bunch of worksheets? Thank you, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i disable macros? | Excel Discussion (Misc queries) | |||
Disable macros | Excel Programming | |||
Disable Macros through VBA | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
en-/disable macros pop-up | Excel Programming |