LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default How to enable a macro permanently so that it doesn't ask at start up?

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)
ToolsDigital 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,
--
AP

"Athena" a écrit dans le message de news:
...
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Start Macro Daily task GoBucks Excel Discussion (Misc queries) 1 November 10th 05 04:34 PM
macro to start on workbook opening Nigel Excel Discussion (Misc queries) 1 May 13th 05 12:39 PM
enter data in cell which will start macro to move data to sheet2 Tommy Excel Discussion (Misc queries) 0 May 12th 05 05:00 PM
Enable Macro PW11111 Excel Discussion (Misc queries) 2 December 14th 04 01:09 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"