View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default Determining if Other Workbooks Are Open

Excel 2003. I have placed a button on my workbook's "switchboard" and want
to do the following when the button is depressed:

1. If there are other workbooks opened, then just close this workbook
(Activeworkbook.Close)
2. If there are no other workbooks opened, then quit the Excel application
(Application.Quit)

How may I test to see if there are any other workbooks opened before I take
one of the above two actions? Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org