Auto-Enable Macro's

[bhawane]

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

[JPW]

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
news:[email protected]...
>
> 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
>