How to enable a macro permanently so that it doesn't ask at start up?

  • Thread starter Thread starter Athena
  • Start date Start date
A

Athena

Hi,

I am using a macro that I had downloaded from MS to manage my budget. Each
time I load the workbook, it asks me whteher enable the macro or not. Can I
enable this macro in a way that it doesn't ask me each time I run it since
it is a trusted macro? Thank you.

Cem
 
Please forgive inaccurate translation from french

Run C:\Program Files\Microsoft Office\Office\selfcert.exe to create a
certificate with your own name
Open your Workbook in Excel
Switch to VBA (Alt-F11)
Tools>Digital signature
Click Choose...
Select your signature
Click OK
Get back to Excel
Save your workbook
Close your workbook
Re-open the workbook
Excel says it could not authentify the signing autority
Select "Always trust... <your name>'
Click OK

Et voilà!

Cheers,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Enabling Macros 3
problem with macro setting 1
EXCEL 2007 Macro Security Being Ignored 9
Excel 2007: Saving a file with a Macro 1
enable macros in 2007 1
security alert on macro-enabled worksheet 2
How to permanently activate Macros? 7
Run Macros in a Password-protected workbook? 1

Back
Top