Excel doc on the net

S

Stewart

I've got an excel document on a web server, when a client
closes the workbook I would like it NOT to say 'This
document has been modified would you like to save changes'

I've tried using the 'beforeclose' workbook event but that
gets triggered after that message has appeared and been
responded to.

Any ideas?

Thank you for any help anyone can give me with this.

Stewart Walker
MOS Excel Expert
 
A

Anya

One way you can accomplish this is to start the excel
application, in which the workbook will be opened, from
VB. That way you can place this code in the VB program:
Set objExc = New Excel.Application
objExc.DisplayAlerts = False

and avoid being prompted.

Hope this helps.
 
Top