Hyperlink a cell to open a workbook tab (bring into focus)

[maxmadx]

Can you create a hyperlink in a cell to open another tab in the workbook? (I know this sounds lazy, why dont you just label the tab and just click it!).

There is a good reason. I have codes in the lead worksheet which refer to stuff in other tabs, but would be good to just click one of them and the other worksheet comes into focus.

Thanks

 

[pboltonchina]

Select the cell in your lead sheet, right click and select 'Hyperlink', then 'Place in this document'. That shows a list of all the sheets in your workbook, select the sheet you want and put the cell you want to link to in the top box and click OK.