Enabling Macros

[Halen]

Hey Guys, a little help here!

I have designed an excel spreadsheet that is found on a network hard-drive so that multiple people can edit it. It is not shared <only 1 person can have it open for editing at once> and it is very reliable on macros.

Usually when the spreadsheet is opened you get the usual message that it contains macros, and the user can decide if they want to enable or disable them. However my colleague no longer receives that message, the macros are automatically disabled

I assume it is something to do with that particular program, as I can still open the same document and use the macros. Is there some way to configure the computer to allow macros? Otherwise has anyone got any ideas??

Many thanks,

H

[Halen]

....anyone <?>

[Ivan F Moala]

Hi Helan

Xl2000 onwards
Make sure security is NOT above High
Tools > Macro > Security

Xl97
Make sure Users haven't Disabled (unchecked) the "Always ask before opening workbooks with macros" checkbox