How to save doc userform minus the macro

G

Glenn

Hi,
I have a protected document with userform and macro running some validation
on the formfields which I save with a different doc name. How can I save
it
without the macros?

Your help is much appreciated.

Glenn
 
J

Jezebel

Your macros should be in a template from which the document is created. The
document won't have the macros.
 
G

Glenn

Hi Jezebel,
I might have done something wrong. I created a new template (claim.dot)
with formfields, wrote the macro
then save the claim.dot. I also saved the same .dot file as claim.doc.
Everytime I open the claim.doc
I could also edit the macro which I wrote in claim.dot. I copied claim.doc
over to a different computer
but still the macro is there.

I guess my question should be - how do I create a claim.doc from my
claim.dot without the macro being
imported into the .doc file.

Thanks.

Glenn
 
J

Jezebel

Saving Claim.dot as Claim.doc is the mistake. You should be using File > New
and selecting Claim as the template. That bases the new document on the
template and gives you access to the macros and code in claim.dot, but
(unless you've written code to do it) the macros are not copied to the new
document.
 

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

Top