BanishWebToolbar Macro doesnt work

[Noel]

Hi, I had a reply to an earlier post directing me to a
site that gave the following Macro code to stop the Web
Toolbar popping up when you open a Mail Merge document
using a Hyperlink address. I have put this macro in the
Mail Merge document and it has no effect - the Toolbar
pops up as always. Any ideas? Thanks, Noel

Public Sub BanishWebToolbar()
CommandBars("Web").Enabled = False
End Sub

 

[Jay Freedman]

Hi, Noel,

You shouldn't put the macro in the merge document. Put it in a template (see
http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm) and run it once.

 

[Noel]

Thanks Jay. My database (and Word) is in a multi user
environment, thats why I thought it would be best to put
it in the MM doc, which is unique to my Db users. Will I
be able to do as you say? Also, sorry to be dense but what
do you mean by run it once. Do you mean create a new
document using this template, or go through all my
existing MM docs and recreate them using this template?
What will this do for all the other users of word in this
multi user environment? Lastly, is it inevitable that
users will have to live with the other pop up screen that
now appears, telling them that a macro is present in the
document etc etc? Seems like Im working towards getting
rid of a pop up menu only to be presented with a pop up
warning - one step forward one back. Thanks again, Noel

 

[Noel]

Hi again Jay. As I said i other thread very sorry for
mucking you about. Great answer on other post. I wont
expect any further answers on either thread unless I get
back to you. Thanks again. Noel