ExcelBanter - Any suggestions?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Any suggestions? (https://www.excelbanter.com/new-users-excel/210870-any-suggestions.html)

doss04

Any suggestions?

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?

Gary''s Student

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?

All times are GMT +1. The time now is 02:37 AM.