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