Macros in Office 2007

[eileenj]

We have several macros created in word & excel in 2003 that prompt us with vb
user forms, or some other things in excel.
None of these macros are digitally signed.
It seems that office 2007 won't run them unless they are signed.
If this is the case (?), how do I create a digital signature without having
to go to an external certificate authority? Is there some way we as an
organisation can create these signatures and allow a couple of staff to
digitally sign macros using it?

 

[Renny Bosch]

I had the same problem and solved it by going into the Developer tab, then
Macro Security, and checking the box "Trust access to the VBA project object
model".

 

[Patrick Schmid [MVP]]

That won't solve the problem.
Office 2007 supports the concept of a trusted location. So if your
documents/templates with the macros are in a location that is trusted by
Office, a digital signature shouldn't be required.
You should be able to create a digital certificate by the way with the
certificate service on a Win2003 Server.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[Renny Bosch]

Thanks for the clarification, Patrick. I should have added that I put my
Excel macros into the XLSTART folder under Documents and Settings | {Owner}
| Application Data | Microsoft | Excel. I haven't checked to find the
corresponding location for Word.

Renny

That won't solve the problem.
Office 2007 supports the concept of a trusted location. So if your
documents/templates with the macros are in a location that is trusted by
Office, a digital signature shouldn't be required.
You should be able to create a digital certificate by the way with the
certificate service on a Win2003 Server.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I had the same problem and solved it by going into the Developer tab,
then
Macro Security, and checking the box "Trust access to the VBA project
object
model".

 

[Patrick Schmid [MVP]]

So your file is in a trusted location already. That should allow the
macros to do everything but access the VBA project object model. You
really need to allow that only if a particular macro needs it. Otherwise
that setting should not be set.

In Word, you can find the location via Office Button, Word Options,
Advanced and find the button labeled File Locations.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Thanks for the clarification, Patrick. I should have added that I put my
Excel macros into the XLSTART folder under Documents and Settings | {Owner}
| Application Data | Microsoft | Excel. I haven't checked to find the
corresponding location for Word.

Renny

That won't solve the problem.
Office 2007 supports the concept of a trusted location. So if your
documents/templates with the macros are in a location that is trusted by
Office, a digital signature shouldn't be required.
You should be able to create a digital certificate by the way with the
certificate service on a Win2003 Server.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I had the same problem and solved it by going into the Developer tab,
then
Macro Security, and checking the box "Trust access to the VBA project
object
model".


We have several macros created in word & excel in 2003 that prompt us
with
vb
user forms, or some other things in excel.
None of these macros are digitally signed.
It seems that office 2007 won't run them unless they are signed.
If this is the case (?), how do I create a digital signature without
having
to go to an external certificate authority? Is there some way we as an
organisation can create these signatures and allow a couple of staff to
digitally sign macros using it?