Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.windows.server.sbs
|
|||
|
|||
Excel Macro Security Problem - Trusted macros not running for users (but do run for domain admins)
Hi All, We have a slightly odd situation that I cannot understand. *Background* We are running Excel 2000 and have been for many years. We have a number of excel files with macros signed with a local certificate, and macro security is set to high. These files opened and ran the macros fine. *Recently* We have just upgraded Outlook 2000 to Outlook 2003. It appears that in doing that update, macros in Excel will no longer work - they are all disabled even for 'medium security' settings (low security allows the macros to run). If we make the user a domain admin then everything works fine. If we then subsequently take the user back to a standard user, everything works fine still. *Issue* We don't really want to have to go around each individual user, elevate their rights, run OL and Excel, and then reduce their rights again - that would take ages and would be a major pain for the users too. I am hoping that someone might know if there is some registry key (or other location) that the users need to have write permissions to make this work? If so, we can more easily deploy a permission change on that key using GP or a login script or similar. Thanks in advance for any help you can provide, -- Alan. The views expressed are my own, and not those of my employer or anyone else associated with me. My current valid email address is: This is valid as is. It is not munged, or altered at all. It will be valid for AT LEAST one month from the date of this post. If you are trying to contact me after that time, it MAY still be valid, but may also have been deactivated due to spam. If so, and you want to contact me by email, try searching for a more recent post by me to find my current email address. The following is a (probably!) totally unique and meaningless string of characters that you can use to find posts by me in a search engine: ewygchvboocno43vb674b6nq46tvb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running macros without lowering security | Excel Discussion (Misc queries) | |||
Prevent end users from manually running or recording macros | Excel Programming | |||
Prevent users from running macros | Excel Programming |