Opposite to "Application.SaveWorkspace"

R

Richard Alexander

Hi

I am starting to believe that there is no answer, to force a no save!

I need the opposite to Application.SaveWorkspace, so the "Do you want to
save..." dialogue doesn't appear on exit.

As you can tell, I don't want changes made to the workbook, or even the
choice given to people as they exit. Can anybody help me?

Rich
 
G

Goppi

add this into your workbook:


Code
-------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Su
-------------------



cheers,
gopp
 

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

Top