Hi All! I have created an Excel Template and within that
template I have a macro that automatically opens a form
when the document opens. I want to disable the macros in
the template after I have made the necessary changes.

To sum it up, I want to open the template, enter the
information in the form, click the ok command button
(which takes the information from the text boxes and put
them into my document), and then I want to disable my
macros and save the document so I can send it out to
clients.

Note: I have everything created except for a way to
disable the macros. Does anyone have any suggestions??

TIA and Happy New Year!
Julie

Hi Julie

See my earlier answers to "Worksheet Mailing Conditions" or "Only Show
Userform Once" - doesn't disable the macro completely but can allow you to
do nothing....

Regards

David


"Julie" wrote in message
...
Hi All! I have created an Excel Template and within that
template I have a macro that automatically opens a form
when the document opens. I want to disable the macros in
the template after I have made the necessary changes.

To sum it up, I want to open the template, enter the
information in the form, click the ok command button
(which takes the information from the text boxes and put
them into my document), and then I want to disable my
macros and save the document so I can send it out to
clients.

Note: I have everything created except for a way to
disable the macros. Does anyone have any suggestions??

TIA and Happy New Year!
Julie