Excel doc on the net

  • Thread starter Thread starter Stewart
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeps returning to Excel 2003 for new workbooks in Excel 2007 1
Workbook Question 2
CAN I PERMANENTLY CHANGE COLORS IN THE 2003 EXCEL PALETTE 1
Embedding a Word Doc in Excel 2007 2
Creating automated word documents from info on Excel. 1
Excel crashes on close 2
Excel workbook will not save 2
Trigger Event on Format Change 4

Back
Top