View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin R Kevin R is offline
external usenet poster
 
Posts: 27
Default Check if Any workbooks are open

How do I check to see if ANY workbooks are open before running a macro? I
know how to check to see a particular workbook is open but I just want to
check to see if a (no specific) workbook is open before continuing the macro,
otherwise display a message if no workbook is open.