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

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


.



.

Hi Julie

The code / forms can be locked (from the casual viewer) with passwords but
there's software out there to crack this protection.

If you don't want the warning box there only 2 ways to stop it:

set their security level to low (not likely or very practical)

or

manually remove the modules once the work is done. (even having empty
modules present causes the warning to be generated)

I think, therefore, that it's going to have to be done by you by hand each
time - sorry....

Regards

David

BTW, if you ever prove me wrong (quite possible!) can you let me know how
you achieve this? david at digicon dot com dot au


"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


.



.

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


.



.