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

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