Any suggestions?

  • Thread starter Thread starter doss04
  • Start date Start date
D

doss04

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")
 
Back
Top