Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / May 2007

Tip: Looking for answers? Try searching our database.

Cannot add digital signature to macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RealGomer - 02 May 2007 13:59 GMT
I have numerous spreadsheet that I've been using for the past ten years. Way
back when I created macros to sort the data in various ways and then assigned
the macros to control buttons. They always ran just fine until we upgraded to
Excel 2003. Now the problem.

Doing a query over in the General Questions forum for "digital signature"
return about a dozen responses. I tried creating a personal certificate using
Office Tools, moving the certificates from Certificates - Current User >
Personal to Trusted Root Certification Authority > Certificates. I ran the
Detect & Repair utility from the Help menu. Nothing will let me open the
macros at our office's required security level of High. Medium requires I
authorize the macros every time.
When I try to digitally sign the macros, the certifcates aren't even in the
list from to choose. In fact, that dialog box is empty.
Is there any way to fix this lovely state of affairs so I can run my own
macros on my own spreadsheets with security set at High?
Signature

I know enuff to be dangerous.

Gord Dibben - 02 May 2007 19:58 GMT
Are you trying to choose a certificate from the VBE Tools>Digital Signature or
from within Tools>Options>Security>Digital Signatures?

Are you logged in Administrator?

If not, what type of permissions do you have?

Gord Dibben  MS Excel MVP

>I have numerous spreadsheet that I've been using for the past ten years. Way
>back when I created macros to sort the data in various ways and then assigned
[quoted text clipped - 12 lines]
>Is there any way to fix this lovely state of affairs so I can run my own
>macros on my own spreadsheets with security set at High?
RealGomer - 02 May 2007 21:52 GMT
Signature

I know enuff to be dangerous.

> Are you trying to choose a certificate from the VBE Tools>Digital Signature
Don't rightly know where this is.
or
> from within Tools>Options>Security>Digital Signatures? From here
>
[quoted text clipped - 20 lines]
> >Is there any way to fix this lovely state of affairs so I can run my own
> >macros on my own spreadsheets with security set at High?
Gord Dibben - 02 May 2007 22:22 GMT
With your workbook open hit Alt + F11 to go to the Visual Basic Editor.

CTRL + r to open the project explorer.

Select your workbook/project then Tools>Digital Signature and pick "Choose"

Do you have a choice of your selfcert signatures?

This is where you add a signature to a workbook.

Gord

>> Are you trying to choose a certificate from the VBE Tools>Digital Signature

>Don't rightly know where this is.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.