|  | digitally signed macros |  | |
| | | Brian |  |
| Posted: Fri Jul 18, 2008 4:25 pm Post subject: digitally signed macros |  |
Our company has just migrated to Office 2007 and we are going nuts trying to get our existing macros to work properly. How do most companies handle macro security? Should we be digitally signing all of our macros and set our workstations to only accept macros that we have created and, if so, how do we achieve this? |
| |
| | | Bob Phillips |  |
| Posted: Fri Jul 18, 2008 5:59 pm Post subject: Re: digitally signed macros |  |
How about storing them in a Trusted folder?
You need the Developer tab visible
Click the Orange Office button
Click the Excel Options button
Select Popular from the left-hand menu pane
In the right-hand pane, click the 'Sow developer tab in the Ribbon' checkbox
record macro is then found in the Code Group of the Developer ribbon.
and then goto Macro Security>Trusted Locations and add a folder there.
-- __________________________________ HTH
Bob
"Brian" <Brian@discussions.microsoft.com> wrote in message news:F8D37EA7-A74E-4E68-9232-3964C843A8E5@microsoft.com...
| Quote: | Our company has just migrated to Office 2007 and we are going nuts trying to get our existing macros to work properly. How do most companies handle macro security? Should we be digitally signing all of our macros and set our workstations to only accept macros that we have created and, if so, how do we achieve this? |
|
| |
|
|