I would like to find a simple way to use a command button or cell in my
master wookbook to open a sheet in another workbook. Any suggestions?

Put a hyperlink to the sheet in the other workbook in some cell of the
original workbook:

=HYPERLINK("file:///C:\Documents and
Settings\Owner\Desktop\Book2.xls#Sheet2!B9")



--
Gary''s Student - gsnu200814


"doss04" wrote:

I would like to find a simple way to use a command button or cell in my
master wookbook to open a sheet in another workbook. Any suggestions?