Hello,
I am looking for a way to disable the close all command that
appears on the file menu when you hold down shift then click on file. I
want to leave the close command in place. I have tried adding my own
button that enters a close routine to circumvent this issue, however I
am saving the workbooks to a database instead of a file system. This
save process causes the excel application to repeatedly ask the use if
they want to save the file before closing. They click yes it saves then
asks again if they want to save, over and over again until no or cancel
is clicked.
Again, I am looking to be able to keep close all from appearing in
the file menu when you hold down shift and click on file.
Thanks in advance

When you save workbooks to "a database" why not mark them as saved at the
same time -

wb.Saved = true

Regards,
Peter T

"LoDawg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
> I am looking for a way to disable the close all command that
> appears on the file menu when you hold down shift then click on file. I
> want to leave the close command in place. I have tried adding my own
> button that enters a close routine to circumvent this issue, however I
> am saving the workbooks to a database instead of a file system. This
> save process causes the excel application to repeatedly ask the use if
> they want to save the file before closing. They click yes it saves then
> asks again if they want to save, over and over again until no or cancel
> is clicked.
> Again, I am looking to be able to keep close all from appearing in
> the file menu when you hold down shift and click on file.
> Thanks in advance
>