Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Auto-Enable Macro's


I have been looking in various forums, and found that macro's cannot b
auto-enabled, unless a certification has been created and assigned
What I want to know is how do you do that

--
bhawanePosted from http://www.pcreview.co.uk/ newsgroup acces

  #2   Report Post  
Posted to microsoft.public.excel.programming
JPW JPW is offline
external usenet poster
 
Posts: 6
Default Auto-Enable Macro's

Check in your Microsoft Office Tools program group and see if you have an
item called Digital Certificate for VBA Projects. This will allow you to
create a self-signed certificate which you can sign your Excel files with.
Simply give your certificate a name and it will be automatically generated.
Then from Excel, press ALT-F11 to access the VBA project, go to the Tools
menu then Digital Signature. Press the Choose... button and select your
certificate from the list (it will probably be the only one there), and
click OK twice.

"bhawane" <bhawane.1qzic4@ wrote in message
...

I have been looking in various forums, and found that macro's cannot be
auto-enabled, unless a certification has been created and assigned.
What I want to know is how do you do that?


--
bhawanePosted from http://www.pcreview.co.uk/ newsgroup access



Reply
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
How to disable the pop up for enable auto update? Eric Excel Discussion (Misc queries) 2 April 16th 10 05:12 AM
auto sum not working - how enable? ALOTT5K Excel Discussion (Misc queries) 2 November 19th 08 09:41 PM
How can I enable auto complete? ValHearon Excel Discussion (Misc queries) 2 March 28th 08 05:18 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
enable/disable macro's dialog? Trevor Shuttleworth Excel Programming 0 August 19th 03 10:14 PM


All times are GMT +1. The time now is 11:05 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"