There must be at least one workbook open, the one with the code.

If Application.Workbooks.Count 1 Then
...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kevin R" wrote in message
...
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.