Auto Cancel Dialog Box

[Webgeek]

Is there a way to auto cancel the "This Document has been modified, do you want to save changes?" dialog box when opening a hyperlink from a web based Excel spreadsheet?

 

[dk]

Hello,

You could use this:-

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Saved = True
End Sub

This needs to go in the Workbook code module, not a standard module. To do this right click the lower of the two Excel icons on the left hand side of your screen and choose View Code.

 

[Webgeek]

Thanks for the reply, but it didn't work.

Trying to figure out how to "Cancel" the dialog box, not Save or Not Save. I'm not familiar enough with VBA to get it!

Thanks for the info tho, if you know of any other way, please reply.