Dave Marshall
New Member
- Joined
- Feb 4, 2005
- Messages
- 8
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.
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.
