Preventing a word document based on a template containing VBA code from the template

[Bill McLean]

I am creating a template for a client. In order to make things easy for the
client to create a document, I have automated a number of tasks using VBA in
the template. However when the client wants to send out the document there
should be NO VBA code as part of the 'published' document. Any suggestions
on how to do this?

Bill

[Jezebel]

By the sounds of it you're not creating a real template but a document that
the user duplicates by using SaveAs. Use real templates (.dot file) -- and
your problem disappears. Documents based on a dot template don't inherit the
template's code.

If you're doing work for a client based on this level of knowledge, I hope
your professional liability insurance is up-to-date...:)

"Bill McLean" <Bill_...@mcleansoftware.com> wrote in message
news:%2353qali...@tk2msftngp13.phx.gbl...

[Bill McLean]

Thanks,

I wanted confirmation that the document would not have any macros stored as
part of the the document. It seems that the user that is using the template
is in fact creating documents from the template using save as:) I had
trouble replicating the problem reported, but now you have given me a
senario that explains what the user has observed.

Bill
"Jezebel" <dwa...@heaven.com.kr> wrote in message
news:uVN5Erii...@TK2MSFTNGP10.phx.gbl...