macro closing worksheet

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

Guest

I have a macro which opens and closes a worksheet.
Problem: when the worksheet is closed by the macro, it prompts me "Do you
want to save".

Is there anyway to get rid of this? There are a lot of opening and closing
worksheets, so this is kind of annoying.

Thanks for your help
 
Application.DisplayAlerts = False

and reset after.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top