I open a number of other workbooks to coolect and alter data but sometimes
one or more of those workbooks are in use by another user. If it is in use
then I would like to just skip that workbook.

How can I test to check if the workbook is in use before I try to open it?

Thanks for any help
Fred