macro protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Macdonald - 06 Sep 2005 13:05 GMT

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 ?

Reply to this Message

Chuck Henrich - 06 Sep 2005 14:53 GMT

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.

Signature

Chuck Henrich
www.ProductivityApps.com

> 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.
[quoted text clipped - 8 lines]
> kill me.
> How can I get Word to recognise them ?

Reply to this Message

David Macdonald - 06 Sep 2005 15:06 GMT

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.

> Is there a particular reason why the template needs to be stored on the
> server rather than locally for each user?
[quoted text clipped - 17 lines]
> > kill me.
> > How can I get Word to recognise them ?

Reply to this Message

Chuck Henrich - 06 Sep 2005 15:16 GMT

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.

Signature

Chuck Henrich
www.ProductivityApps.com

> Thanks, Chuck
> Could you expand on using a script that downloads the latest template on
[quoted text clipped - 23 lines]
> > > kill me.
> > > How can I get Word to recognise them ?

Reply to this Message

David Macdonald - 06 Sep 2005 15:26 GMT

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

> The logon script would be something that your system administrator would
> write and then configure the logon procedure to run automatically on logon.
[quoted text clipped - 30 lines]
> > > > kill me.
> > > > How can I get Word to recognise them ?

Reply to this Message

Chuck Henrich - 06 Sep 2005 15:33 GMT

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.

Signature

Chuck Henrich
www.ProductivityApps.com

> He's sitting opposite me smoking heavily despite the ban so I'll have to pick
> my moment carefully.
[quoted text clipped - 34 lines]
> > > > > kill me.
> > > > > How can I get Word to recognise them ?

Reply to this Message