I have written some code in a data entry spreadheet I have
sent out to some end users. However when they open the
spread the macros are not working . I told them to make
sure they select enable macros on opening but apparently
the spread just opens without asking that question.

Anyone know if there's a way of forcing the enable/disable
macros box to appear regardless of the user's local
settings? If not, perhaps there's an aspect of their
local configuration they can tinker with to make this
happen (assuming enabling macros is the problem!)?

Sounds like the users have security set to High. They have to reduce it
manually (Tools, Macro, Security) or they cannot run your macros. There is
nothing you can do to force this.

--
Jim Rech
Excel MVP

Hi,



Their security is too height. Go to Tool Macro Macro. and then select
security. Set it to medium, they will be ask from now on.




--
JP

http://www.solutionsvba.com


"James" wrote in message
...
I have written some code in a data entry spreadheet I have
sent out to some end users. However when they open the
spread the macros are not working . I told them to make
sure they select enable macros on opening but apparently
the spread just opens without asking that question.

Anyone know if there's a way of forcing the enable/disable
macros box to appear regardless of the user's local
settings? If not, perhaps there's an aspect of their
local configuration they can tinker with to make this
happen (assuming enabling macros is the problem!)?