View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen C Stephen C is offline
external usenet poster
 
Posts: 51
Default Check for open workbooks

How do i check to find out if any other workbooks are open?

I need to do this check in a macro therefore require the VBA code.

I have a workbook with a macro in, when a user runs this macro i need it to
check to see if any other workbooks are open. This macro will not run
correctly if others are open.

I am using Office 2000 - SP3