Macro enabled template

Question

I have designed a macro enabled template with buttons which when clicked run macros that are saved to the template. Unfortunately when I create a new workbook from the template, the macros buttons don't work.  Does this have something to do with the security settings for new workbooks?  How do I fix it?  Thanks

Answer 1

When you open a document whose VBA project has been digitally signed for the first time, you should be asked whether you want to trust the certificate. If you answer Yes, it should automatically be added to Trusted Publishers.

Answer 2

In developer tab click "macro settings" and change the security level to something lower.

You may find it useful to create your own certificate (with "selfcert" which is somewhere in the /Programs/Microsoft Office/Office12 folder) and then add the certificate to the trusted ones (Windows Key + R > certmgr.msc > select the trusted group in the tree box, right-click, add the certificate).

And then, back in VBA, under Tools I think, there's a Digital signature option.

Answer 3

In 2007 you don't need a digital signature...............just make sure you save the workbooks into a Trusted Location as Hans has pointed out.

If you do want to use a selfcert signature....................

See apo__1 reply

I will add this info to that reply........

After creating one it will be placed in your Personal Certificates Store.

You have to move or copy it over to your Trusted Publishers Store.

Start>Run  certmgr.msc

Double-click on Personal Certificates to open.

Select the selfcert you created and drag over to Trusted Publishers.

When in VBE go to Tools>Digital Signature and Choose.

Save the workbook.

Gord

Answer 4

If I've created a digital signature for my VBA projects, do I add it to my Trusted Locations or should there be a way to add it to Trusted Publishers?  The latter option is grayed out in my Trust Center options.

Answer 5

Make sure that the new workbook is saved in a trusted location.