Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Name truncated in digitally signing?

Can anyone shed light on this?

My company got a certificate or VBA digital signing ID for digitially
signing VBA macros inside MS Office. It was issued from VeriSign.
Everything's fine, but the Security Alert dialog box, where the user
chooses to trust the source and enable macros, shows our company name
WITHOUT "Inc". It shows truncated from "XXX Company, Inc." to "XXX
Company,".

Every property in the certificate shows it correctly, but in the dialog
box mentioned above, it truncates. VeriSign can't figure it out and
they are blaming Microsoft, saying I have to call them. I will, but in
the meantime, I'd like to know if anyone has any thoughts on this.

Thanks,
Chuck

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Name truncated in digitally signing?

The problem seems to be due to the "&" in our company name. It cuts off
text from there in the MS Security dialog box where it asks the user to
trust the source.

I know I'm not the only company with an "&" in it's name, so I'm asking
if anyone else has come across this problem?

-Chuck

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 219
Default Name truncated in digitally signing?

Hi mateland,
While I don't have an answer for you, I DO want to thank you for keeping
our community up on what's happening with this issue. As far as I know, It's
a new one on us.
Thanks and again, sorry I don't have an answer for you.
Sincerely,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"c mateland" wrote:

The problem seems to be due to the "&" in our company name. It cuts off
text from there in the MS Security dialog box where it asks the user to
trust the source.

I know I'm not the only company with an "&" in it's name, so I'm asking
if anyone else has come across this problem?

-Chuck


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Name truncated in digitally signing?

MS help (premium access) never answered the phone, so I put in a call
record via the Web, but I'm not holding my breath I'll get an answer
anytime soon. <g

In the meantime, with deadlines already expired, I researched more on
my own. I built certificates using Selfcert where I included the "&" in
the name trying to grasp a pattern or logic to all this. Invariably the
name was truncated by the MS Office Security dialog box. (That's the
dialog box all Office files pop up when a macro is in the file being
opened. If a certificate is assigned to the macro, which MS recommends,
then the name of the developer/company is displayed and the user can
choose to trust the source and never be bothered again with the
warning. My point is this is a very commonly viewed dialog box, so the
problem is not obscure.)

And it's not a fluke. Anyone can see this for themselves. It's very
reproducable and only takes a few seconds to set up:
1) Launch Selfcert.exe (In the Office folders).
2) When prompted, set the certificate name to anything an "&".
("Beavis & Butthead")
3) Finish the certificate.
4) In ANY MS Office program make sure macro security is set to Medium
or higher (Tools Macro Security).
5) Start a new document and make a simple macro (recording one is
fine).
6) In the VBE sign the certificate to the macro (Tools Digital
Signature).
7) Save the document, close it, then re-open it.
8) The Office security dialog box appears asking to enable macros with
a checkbox asking to trust the source in the future.
9) STOP and look at the name of the certificate source at the top of
the dialog box. Instead of "Beavis & Butthead", it shows only, "Beavis
&". OOPS!

Further testing showed that if I add a space and a punctuation to the
end of my certificate name when setting it up, the whole name magically
appears in the dialog box. It seems the "&" cuts off text like a
delimiter, then the space+punctuation restores it. Go figure.

See if for yourself. Using the steps above, make a new certificate but
make the name "Beavis & Butthead -" (note the spaces). In the dialog
box the name now displays correctly. The caveat is the technical
properties of the certificate display "Beavis & Butthead -". But that's
better than the first scenario. Most users won't look at that anyway.

It sounds funky, but at least I found a workaround. The only outcome
from Verisign and MS pointing fingers at each other is that I lost lots
of money and time. I'm happy I found a solution so I can move on past
this problem.

So, there you have it. I hope this helps someone in the future so they
don't have to go through the frustrations I had to deal with proving to
these large corporations I'm not insane and that I didn't create the
problem as they tried insinuating.

I'm all ears if anyone has other thoughts on this.

Thanks,
Chuck

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Name truncated in digitally signing?

For the full answer, including comments from MS, see the following
thread in the VBA group.

http://tinyurl.com/cfz2o

-Chuck

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
Having Trouble Digitally signing a macro JHL Excel Discussion (Misc queries) 0 August 31st 08 07:13 PM
Digitally signing VBA Project Michelle Excel Discussion (Misc queries) 3 November 11th 07 01:25 PM
digitally signing excel doc Gixxer_J_97[_2_] Excel Programming 0 July 2nd 05 01:54 AM
Can not digitally sign Sharad Naik Excel Programming 4 November 11th 04 04:39 AM
Digitally Signing Macros Robert[_15_] Excel Programming 0 September 10th 03 09:58 PM


All times are GMT +1. The time now is 08:01 PM.

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"