F
faris_idris
Hello all I have two question.
1. how suppress the "Disable Macros" box when a document with macros
is opened automatically.
So far I have read a lot about is by going to the
tools-->options-->general and un-checking Macro Virus Protection as
well as application.Options.VirusProtection = False. My question is
how do I put this code to fire up before the document opens up. Please
bare in mind the document/template will be located in the network and
there are too many users to go to each machine and set
tools-->options-->file locations-->Workgroup templates to be of the
network folder name.
2. My second question deals with suppressing message boxes related to
the application and not the document. When I am in the document and I
copy a few pages of data and try to close the document, I have it set
so the message box prompting me to save is disabled but when I try to
close the Word application it says "You placed a large amount of text
on the clipboard. Do you want this text to be available to other
application after you quit Word? YES NO Cancel". I would like to
choose yes without the user seeing this message box. How will I be
able to do this?
Thanks in advance for any help you provide, this is my first day
working with VBA
Faris
1. how suppress the "Disable Macros" box when a document with macros
is opened automatically.
So far I have read a lot about is by going to the
tools-->options-->general and un-checking Macro Virus Protection as
well as application.Options.VirusProtection = False. My question is
how do I put this code to fire up before the document opens up. Please
bare in mind the document/template will be located in the network and
there are too many users to go to each machine and set
tools-->options-->file locations-->Workgroup templates to be of the
network folder name.
2. My second question deals with suppressing message boxes related to
the application and not the document. When I am in the document and I
copy a few pages of data and try to close the document, I have it set
so the message box prompting me to save is disabled but when I try to
close the Word application it says "You placed a large amount of text
on the clipboard. Do you want this text to be available to other
application after you quit Word? YES NO Cancel". I would like to
choose yes without the user seeing this message box. How will I be
able to do this?
Thanks in advance for any help you provide, this is my first day
working with VBA
Faris