PrashanthGM12345
Member
Hi i have a workbook withv 10 sheets.
sheet 1 should be the index sheet containing hyperlinks to all the other 9 sheets.
sheet 1 is unhidden and all other 9 sheets are hidden.
When i click on the hyperlink to sheet 2 in index sheet, it should open the sheet2 and when i click on back icon on sheet 2, it should hide sheet 2 and go back to index sheet.
similarly i should do for all the other sheets.
how can i do it with excel vba macros. can anyone guide me step by step. i am new to macros vba.
sheet 1 should be the index sheet containing hyperlinks to all the other 9 sheets.
sheet 1 is unhidden and all other 9 sheets are hidden.
When i click on the hyperlink to sheet 2 in index sheet, it should open the sheet2 and when i click on back icon on sheet 2, it should hide sheet 2 and go back to index sheet.
similarly i should do for all the other sheets.
how can i do it with excel vba macros. can anyone guide me step by step. i am new to macros vba.