A
Alan
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:
(e-mail address removed)
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
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:
(e-mail address removed)
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