Use an Addin to hold the code. Don't have it in the workbook to begin
with - either that or copy the worksheets to a new workbook.

--
Regards,
Tom Ogilvy

"Julie" wrote in message
...
David,

I don't want the warning box that asks to enable or
disable the macros to pop up, I also don't want anyone
else to access the form or the code. I want the
programming side of the workbook (after it is modified
the first initial time) to be gone or locked. Any
Suggestions?

Thanks for your help!

Julie
-----Original Message-----
Julie

I don't know if it can be done automatically as you'd
have to have some code
present to say "delete the code". The manual way is to
right-click the
module(s) / form(s) in the VBA editor and "remove
{module name}"

Is it critical to remove the them or just to stop
the "this file contains
macros" warning box or?

Regards

David



"Julie" wrote in
message
...
David,
Thanks for your response. Is there any way to wipe out
all of the programming side of the document when the
form
is closed? I don't want to be able to see the form
again
or any of the modules. I only want to see the
wroksheets
in the workbook. TIA!

Julie

-----Original Message-----
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


.



.