Digital Signatures - Checkbox Grayed Out

V

vmottert

Board Regular
Joined
Aug 30, 2003
Messages
215
I have some Excel spreadsheets with VB macros that are distributed to users around the USA. There are digital signatures in the files and most users are able to surpress the macro warning dialog boxes by checking the "Always trust files from this soource" box in the dialog box.

However, for some the "Always trust files from this soource" box is grayed out. So they are not able to surpress the macro warnings.

Anyone know why, and how to fix this? We are all PC users (Macs don't seem to use digital sigantures). I am using Excel 2000. One user this morning is on Excel 2003.

Thanks fore any ideas ...

Vernon
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
In their version of Excel they need to check the Trust Access to the Visual Basic Project, CheckBox.

Excel toolbar: Tools - Macro... - Security..., Trusted Publishers [Tab]

If this does not fix the problem then they may be locked out by a network security profile?
 
Upvote 0
They may need to install the digital signature on the machine before that box will be enabled.

...brb...

Here's some more info on the subject.

Take a look at the macro security level as well. I'm not sure if HIGH or VERY HIGH will let you add trusted sources or no. I know that MEDIUM will. [Hard to test this issue for you because all of my users have already installed my sig. :wink: ]
 
Upvote 0
Thanks Joe, Greg ...

Greg, I think the digital certificate is installed on their machine when they check the box ... but it is grayed out so they can't install it. His security is set to Medium (should have mentioned that), which should be OK. I looked at the link and will pass that along.

Joe, I'll pass your suggestions along. I didn't think about network security. We'll look into that.

Much appreciated !

Regards,

Vernon
 
Upvote 0
Hmmm, my experience has been that box is only grayed out when the sig is not installed. You have to go through the process of installing the digi-sig. Then sometimes even though you have installed the digi-sig, the "always trust..." checkbox is disabled. You have to open the WB, close it and then re-open and the "alway trust..." checkbox is enabled on the 2<sup>nd</sup> opening of the file.

As far as network security goes, I've never seen that impact that checkbox; but Joe knows lots of stuff I don't; so not sayin' it can't happen; only that I ain't seen it.
 
Upvote 0
We have our net security permissions set not to allow user installed certificates, but yes you are right the network settings will not directly effect the checkboxes. Indirectly if you cannot install the certificate [On our system you are not warned and it looks like the install worked, but it did not!] then Office Security takes over and will lock out the checkbox.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Forced to discard digital signature after opening and immediately saving an Macro-Enabled Excel file
Replies
0
Views
625
JDCreate
J
O
  • Question Question
Macros Disabled when sharing file - users don't have the option to Enable
Replies
1
Views
2K
Joe4
Joe4
B
  • Question Question
How to digitally sign an Excel workbook via VBA
Replies
5
Views
4K
becci.gott
B
K
  • Question Question
Trusted Locations
Replies
1
Views
3K
Anthony47
A
R
  • Solved
Excel VBA no automatic break when divide by 0
Replies
4
Views
619
RBachman
R

Forum statistics

Threads
1,226,240
Messages
6,189,822
Members
453,572
Latest member
mrjohn500

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top