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

Bob wrote:
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

No. The entire point of the warning is that a user shouldn't be
blind-sided by macros they don't know about. I think that with VBScript
you can invoke an Excel file in a way that avoids the security warning
(on the theory that if you are able to execute a script then there is
no damage that you could do with an Excel macro that you can't do with
the script) but then you would have to convince your users to run the
script rather than Excel directly, which should raise the suspicions of
anybody computer-savy. Why not *trust* the users? You can make the code
password-protected if you don't want to reveal it.

-John Coleman

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