Alert Message


Posted by David Ross on January 30, 2001 11:46 AM

We are displaying an Excel spreadsheet as a report. The problem is if you click on any hyperlinks to jump to another sheet in the workbook while in the browser you get the Message: "This document has been modified. Do you want to save the changes?" Is there any way to stop the message from appearing?



Posted by Faster on January 31, 2001 5:15 PM

Maybe try this

Sub FromWeb()
Application.DisplayAlerts = False

'as noted earlier, the alerts should be turned back on
'Application.DisplayAlerts = true
End Sub