Hi,
i have been struggling with a macro to select a workbook if it is open, and
open it if it is closed. the details are as follows.
workbook to be opened is S:\QUOTE REGISTER updated
( select sheet year to date )which i can do!!there is a password of babylon

if the book is closed, then it needs to be opened and sheet selected.
if the book is open, then it needs to be made active and sheet selected.

i just cannot seem to do it.

Kindest Regards,

Nigel