macro protection

  • Thread starter David Macdonald
  • Start date
D

David Macdonald

I have created a template that loads a toolbar which is now shared on the
company server. i.e. everyone's startup contains a link.
It does all sorts of wonderful things (most of which I've managed to do
thanks to tips and help found here).
I have installed 2003 on my machine (the rest of the company still has 2000)
and the macro protection set at medium asks me to accept the macros every
time I open Word.
My problem is that I want to keep protection at this level but want the
macros from my own template to be accepted automatically. If the whole net
upgrades to 2003, a week of having to click "accept" and the whole staff will
kill me.
How can I get Word to recognise them ?
 
C

Chuck Henrich

Is there a particular reason why the template needs to be stored on the
server rather than locally for each user?

If you download a copy of the template into each user's Startup folder, you
won't get the security warning and you'll reduce your network traffic (the
latter might have minimal impact). Use a logon script to download the
template from a network location so that every time each user logs on they
get the most up to date copy. That way distribution of updates is automatic.
 
D

David Macdonald

Thanks, Chuck
Could you expand on using a script that downloads the latest template on
logon or point me to where I can find details ?
Sounds like the way to go! Like you say, it will reduce traffic and make
changes much easier.
 
C

Chuck Henrich

The logon script would be something that your system administrator would
write and then configure the logon procedure to run automatically on logon.
It's a batch file that executes a series of command line instructions (for
instance copy x file to y location). You should be able to tell your
sysadmin what file(s) you want to have copied where and he/she should be able
to do that for you no problem.
 
D

David Macdonald

He's sitting opposite me smoking heavily despite the ban so I'll have to pick
my moment carefully.
Thanks for the help.
 
C

Chuck Henrich

Good luck!

If he's not amenable, it's possible to write a macro that would mimic the
logon script functionality but it would be a more convoluted process and
isn't really worth the effort unless for some reason a logon script isn't a
go for "political" reasons.
 

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