How to depress confirmation dailog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Warning dailog in access version 2003 5
How to get Find dialogbox through VBA macro in Excel2007 11
VBA to check Version and Supress safety warning Dailog of Access 3
How to solve the Error of mdb 1
Accepting solver solutions automatically under VBA 3
How to select a Printer 1
Error handling on Form 3
suppressing auto-dailog boxes 1

Back
Top