checking if file is saved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to enter code to check if the file was saved before closing
I am using a form with a close button.

'check here if file has been saved first
??

Worksheets("StartupSheet").Activate
Application.Quit
 
John said:
I would like to enter code to check if the file was saved before closing
I am using a form with a close button.
Click to expand...

Hi John,

If Not ActiveWorkbook.Saved Then
''' The workbook is not saved. Take action here.
End If

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
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

Run-time error '91' 4
Excel process still shows in TaskManager 7
Excel Providing user message when RED X clicked & properly closing application. 2
Save failing 2
Prompt for saving a saved workbook 1
"Getting Rid Of Save Prompt On Quit Command" 3
Excel crashes and restarts when accessing newly created worksheet 2
execution speed issue when closing files 5

Back
Top