Disable Close All
 

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

Disable Close All
 

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

wb.Saved = true

Regards,
Peter T

"LoDawg" wrote in message
ups.com...
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