movin' from sheet to sheet

S

skitek

got little problem with this. 've created worksheet containing grea
number of sheets and hiperlinks. is there any possibility to mak
visible only active sheet ,I mean after i choose hiperlink to othe
sheet - this sheet appears and this one which has been active - i
hiden. thank for help

............. _____________________ d(o_O)b .....
 
B

Bernie Deitrick

Skitek,

You cannot hyperlink to hidden sheets, so hiding the other sheets would
inactive your links. You would need to change from hyperlinks to macros,
where the macro unhides the other sheet, selects the cell, and hides the
original sheet.

HTH,
Bernie
MS Excel MVP
 
Top