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!)?