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


"Barb Reinhardt" wrote:

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.
--
HTH,

Barb Reinhardt



"Ant" wrote:

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