Stopping the confirm popup on file save with same name

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

Guest

I have used this VB excel command before but it was some time ago and I have
forgotten the syntax. I remember that it is a "toggle" . Confirmations are
turned off at the beginning of a macro where you do not want confirms from
the user. Then it is toggled at the end of the macro to put confirmation
back in the normal status.

Help from anyone who recognizes what I'm talking will certainly be
appreciated.

Thanks
 
Is this what you are looking for?

Application.DisplayAlerts = False
Application.DisplayAlerts = True

Regards,

OssieMac
 
OssieMac said:
Is this what you are looking for?

Application.DisplayAlerts = False
Application.DisplayAlerts = True

Regards,

OssieMac
Click to expand...


That's it. Thanks!!
 
You must log in or register to reply here.

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

File save as 1
Delete Worksheets in same excel 4
How do I make a macro seek the botom of a list? 1
Turning off action query confirmation messages 1
XP confirm to open downloaded file 3
How do i stop receiving confirmation of emails 2
Named range in workseet code 8
Accessing the text of a form command button from underlying macro 6

Back
Top