Any suggestions?

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?
 
G

Gary''s Student

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing reference to other workbook 2
Compile data from several workbooks 1
Finding what if IE or Excel is opening a workbook 1
linking workbooks 3
moving sheets between workbooks? 2
Workbook Formats? 3
Deleting data but keep formulas/formatting. 3
quick way to prohibit all editing/changes to workbook (2010) 2

Top