Workbook.Quit

[Guest]

I am sure this is a real simple one, that I have not figured out. I want the
command "Workbook.Quit" that will then give the user the option to save the
workbook. Using Application.Quit is fine if only one workbook is open. But
if other workbooks are open it does not work for the one workbook.

Any help is appreciated.

Thanks

 

[Norman Jones]

Hi Ronbo.

Try:

ActiveWorkbook.Close

If the workbook has changed, the user will be asked if changes are to be
saved.

 

[Guest]

Hi Ronbo.

Try:

ActiveWorkbook.Close

If the workbook has changed, the user will be asked if changes are to be
saved.

---
Regards,
Norman






Thank-you