disable macros?

M

me

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable user interaction in VBA 1
security, enabling macros to enable a disabling saving function 12
Macros disabled, not by security settings? 5
open file with macros disable 1
Notify user macros are disabled. 3
How to split an excel workbook in code and data 2
Stumped - Problem with Macro Security settings? 10
Forcing Macros to Run 2

Top