Macro / trust centre issue with shared file over network

[Dave Marshall]

Hi, I have a shared workbook that functions as a calendar for a group of people (shared file, accessed over a network), with the date held in a single row, to save a bit of time I have created some VBA code to automatically center the users view on the current date when opening the workbook/sheet,

so far so good,

however the majority of the users of the file have macro's disabled by default (with notification enabled), and having them have to click through the security setting to allow the macro to run negates any benefit to having the code in place (they may as well just scroll to where they want on their own).

Is there a simple way to always allow the macro to run without any user input, trusted publishers and digital signatures seems a non starter, but would adding the file location to the list of trusted places (on a network) work?

also whats the easiest way to roll this (or any other solution) out across the user group (~30 users)

Thanks in anticipation.

Dave.

 

[Ruddles]

would adding the file location to the list of trusted places (on a network) work?

That is the way to do it, I would havew thought.

whats the easiest way to roll this (or any other solution) out across the user group (~30 users)

Trusted locations are stored in the Windows Registry - mine are in:-
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Trusted Locations. I know you can manipulate the registry programatically using VBA but I'm sure there's a better way. Group Policies?