Checking whether sheets are already open

[bobeuk]

I am writing a spreadsheet which opens and updates other books. I need to build an error trap which checks first whether the target workbook is open (and if so I wil then not open it). Is there a flag which shows active workbooks?

Cheers

John

 

[Jack in the UK]

Hi --

A great pal has some good stuff on this Dave Hawley try VBA section on http://www.ozgrid.com

Rdgs
==========
Jack

PS this is a good site.. might check Barrie Davidson site hes in the member section of this board, som every nice stuff there