If C references R, opening R will cause C to be opened as well.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Frederick Chow" wrote in
message ...
I have a workbook ("C") which references other subroutines of
another workbook ("R"). When C is opened, R should have been
automatically opened. If somehow R cannot be opened, is it
possible to write code to check the existence of R? Seems that a
IsWorkBookExists macro cannot do the job. Thanks for your advice
in advance.

Frederick Chow