Hide essential worksheets and put the message on the visible sheet. Have
your code enable your project by unhiding the sheet and unlocking things,
moving the message sheet out of the way. It if doesn't run, not much to
work with. In the beforeclose event you would have to "reseal" your
workbook and save it.

Regards,
Tom Ogilvy

"Phil Perry" wrote in message
...
I believe you can't bypass the initial screen in Excel
which asks you to select to disable macros (default button
for pete sake) or enable macros. Is there a way I can
put a message on there to advise the program will not
run unless you enable macros...or other procedure to
overcome this.
cheers