Macro question

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Ok, when running a macro in Excel which automatically
saves changes made to the worksheet - how do you tell
Excel NOT to bring up the "Do you want to overwrite the
existing file" prompt? I know there is a way to do it,
but I cannot think what the code is.... help!
 
Gary,

Use code like the following:

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top