Open a sheet from inside a cell

Copper Contributor

Can I open an exsisting sheet in the same workbook from inside a cell?

4 Replies

@TheFinancialAdvisor 

You can insert a hyperlink to a cell on another sheet in the cell:

S0784.png

Clicking the hyperlink will take you to the other sheet.

Thank you, the link works well. The sheet is shaded when opens. Can it be set to open clear?

@TheFinancialAdvisor 

Shaded? It is activated normally when I try this.

@TheFinancialAdvisor 

 

With the permission of everyone involved, here is this example with VBA.

 

Hope I could help you with these information / links.