Assuming there are macros in the workbook that you want the users to access, you
can digitally sign the workbook and make it trusted.

See help on digital signatures.

Or set the security level to low or nothing as Earl said.........but not
recommended.


Gord

On Thu, 14 Jun 2007 01:34:55 GMT, "Launchnet via OfficeKB.com" <u20911@uwe
wrote:

Gord Dibben wrote:
In addition to Earl's advice..............

Excel 97 and 95 did not have levels of security.

All or nothing is the setting for macros.

I think levels came in with 2000 version.

Gord Dibben MS Excel MVP

Launchnet,

You can set the Macro Security (Tools - Options - Security - Macro security) setting to Low.
It won't warn you of the presence of macros. I suspect that's what the other machines are
doing. It's not a good idea. If a workbook comes along that has macros, you won't know
about it, and if it's malicious, there you go.


Thanks fellows...
I copied the disk to another PC using a floppy and everytime that I open the
workbook it still asks if I want to enable the macro's.

I would think that there is a setting of some type in Excel that would allow
this copied sheet to work without asking the security question each time it's
opened. The user clicking "Enable" the first time when opening the sheet
from the hard disk should thereafter allow the file to opened without having
to manually click "enable".

Any more ideas ?
Thanks