macro closing worksheet
Application.DisplayAlerts = False
and reset after.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jeff" wrote in message
...
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
|