Open a sheet from inside a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2787519%22%20slang%3D%22en-US%22%3EOpen%20a%20sheet%20from%20inside%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2787519%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20open%20an%20exsisting%20sheet%20in%20the%20same%20workbook%20from%20inside%20a%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2787519%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2787543%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20a%20sheet%20from%20inside%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2787543%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1166657%22%20target%3D%22_blank%22%3E%40TheFinancialAdvisor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20insert%20a%20hyperlink%20to%20a%20cell%20on%20another%20sheet%20in%20the%20cell%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0784.png%22%20style%3D%22width%3A%20731px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F313045iAED20F08EDFA7159%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0784.png%22%20alt%3D%22S0784.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EClicking%20the%20hyperlink%20will%20take%20you%20to%20the%20other%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.