Hi all!! Suppressing the "Do you want to save changes"
 

message when I haven't made any! I know I can open it
read-only but I was wondering if there is a way to switch
the alert off.

I have tried application.displayalerts = false but that
doesn't do it.

Any ideas anyone?
Thanks in advance!

Bony Pony

Bony,

You need to use a macro:

Sub CloseWithoutAlert()
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
End Sub

HTH,
Bernie
MS Excel MVP

"Bony Pony" wrote in message
...
message when I haven't made any! I know I can open it
read-only but I was wondering if there is a way to switch
the alert off.

I have tried application.displayalerts = false but that
doesn't do it.

Any ideas anyone?
Thanks in advance!

Bony Pony

Hi Bernie,
Thank you very much.

Have a good day!

Robert
-----Original Message-----
Bony,

You need to use a macro:

Sub CloseWithoutAlert()
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
End Sub

HTH,
Bernie
MS Excel MVP

"Bony Pony" wrote
in message
...
message when I haven't made any! I know I can open it
read-only but I was wondering if there is a way to
switch
the alert off.

I have tried application.displayalerts = false but that
doesn't do it.

Any ideas anyone?
Thanks in advance!

Bony Pony


.