I've written a macro I need to incorporate into a spreadsheet to send out to
other users in the business. At the moment the only time it seems to crash is
if there are no workbooks visible / active when it is set running (which
could happen).

How do I check how many workbooks are currently visible before the rest of
the macro starts running?

Thanks,

Andrew