How to depress confirmation dailog
 

I have an excel sheet where I have written some codes to run when the file
opens.

It works fine. But every time when it opens, it needs confirmation ENABLE
MACRO OR DISABLE MACRO. I dont want the user to get this dailog box. As I
have deliver this file to another users where I dont them to view the code
neither I want them to apprear this selection dailog box.

Any suggestion for doing this.

Regards

Irshad

How to depress confirmation dailog
 

Irshad

Signing the code or making the workbook an add-in and installing that
manually or via an installer will stop the dialog

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Irshad Alam" wrote in message
...
I have an excel sheet where I have written some codes to run when the file
opens.

It works fine. But every time when it opens, it needs confirmation ENABLE
MACRO OR DISABLE MACRO. I dont want the user to get this dailog box. As I
have deliver this file to another users where I dont them to view the code
neither I want them to apprear this selection dailog box.

Any suggestion for doing this.

Regards

Irshad