Using xlsm worksheets on different computers

[Ant]

So I just creaed the greatest spreadsheet ever with lots of Visual Basic and
Macro buttons that makes it a dream for the user to use. A startup macro
opens at the Menu page, lots of hyperlinks to various worksheets, lots of
macro buttons, tabs hidden, VB password protected, hidden worksheets, an
expiry date on the workbook which inhibits further use after a certain date
etc.... You get the idea.

I digitally signed it and installed it on the computer where it will be
used. At the end of each week this monthly file is emailed to a number of
managers, and I soon realised the fruits of my work are useless. The Macro
Security just put a stop on everything I designed. This means that I would
have to digitally sign each email copy onto the computer of each manager.
Also, at the end of each month, the file is copied, cleared of data and the
new month set up which then compounds the problem with a new file each month.

What can I do to get my workbook to work as designed? What is the point of
Excel having all these great functions if it won't work on the next
computer???

Thanks
Frustrated Ant

 

[Barb Reinhardt]

I believe each manager just needs to save the signature tied to that workbook
to their machine. That can be done when they enable the macros. Once that's
done, they'll need to trust the publisher. They'll not have to enable a
macro from you again.

 

[Ant]

Hi Barb,

Thanks for the help.

I created the spreadsheet on my home computer. When I emailed it to my work
computer, there was no option to enable my home Digital Signature on the work
computer. I had to create and install a new digital signature on the work
computer.

Could you point me in the right direction as I could see no option to allow
that.

Ant

 

[Gord Dibben]

Where did you get the Digital Signature?

You mention "create and install".

If you created it using the Office SelfCert tool you cannot export that key
to another computer.

If the users simply move your workbook into a Trusted Location on their
computer a DS is not required.


Gord

 

[Ant]

Hi Gord,

Yes, I created the Digital Signature using "Digital Certificates for VBA
Projects" under Microsoft Office 2007 Tools which, I assume, is the Office
SelfCert tool you referred to.

Hmmm.... Trusted Location. I haven't come across that before. Hopefully
there should be a few threads relating to it in the Excel Programming
Discussions

Regards
Ant

 

[Gord Dibben]

Button>Excel Options>Trust Center>Trust Center Settings>Trusted Locations.

Tell users to store your workbook in a Trusted Folder.


Gord