Caveman,
I do not have this with Office 2000, so I can only guess it's a feature of
later versions.
If it is, then it makes the point of signing your WB pretty useless if no
other machine will honour your certificate.
I guess you'd have to buy a certificate.
Or speak with the Admin to relax the Office policy.

NickHK

"Caveman" wrote in message
...
That's fine, except that I am trying to distribute the spreadsheet with
macros to a my team, and selfcert.exe warns: "Office will only allow you
to
trust a self-signed certificate on the machine on which it was created."
Most users to whom the spreadsheet would go are NOT admins nor PowerUsers
on
their machines so apparently they cannot change the security levels. How
do
I deal with that?

Thanks!
Caveman

"NickHK" wrote:

joe,
You are trying to fight the purpose of macro security.
Look into using SelfCert.exe, which is part of Office, IIRC and sign
your
code.

NickHK

"
wrote
in message ...
"exceluserforeman" wrote:
Tools Macros Security Settings
Set to Low
Close excel
Re Open excel and Security should still be set to low.

Obviously, you do not understand my question. What you
suggest will apply to all workbooks. (And Low would be
very dangerous, in that case.) I asked: how can I apply
the low security to "just this workbook without enabling
macros in any other workbook?".

Obviously, I could toggle security back to High after entering
the workbook. But then I have to toggle security back to Low
when I want to reopen the workbook later. As I wrote earlier,
that would be "tedious".