Change security to low (but can't do that with the workbook causing the
prompt)

Certify the project and have the user accept you as trusted (xl2000 and
later)

Take the macro out of the workbook and run it from another workbook since
you are the only one that needs it.

--
Regards,
Tom Ogilvy


"Bob" wrote in message
...
Hi,
Is there anyway I can hide from the user the Macro Worning box(Disable
Enable Macro). I don't want users to know about this macro. I will be the
only one to run the macro that will change the data.

Thank you