Workbook.Quit

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

Hi Ronbo.

Try:

ActiveWorkbook.Close

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

---
Regards,
Norman



"Ronbo" <[email protected]> wrote in message
news:[email protected]...
>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" wrote:

> Hi Ronbo.
>
> Try:
>
> ActiveWorkbook.Close
>
> If the workbook has changed, the user will be asked if changes are to be
> saved.
>
> ---
> Regards,
> Norman
>
>
>
> "Ronbo" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
> Thank-you