Surender1978
New Member
I have multiple sheets in excel and one main menu which are linked to other sheets but when i hide all that sheets except menu sheet then hyperlink not worked so give me a solution for this.
Required help in Hyperlink
- Thread starter Surender1978
- Start date
mahaveer
Member
unhide all the sheet tab.....
then follow these steps:
1. click the microsoft office button (left top of the excel window in excel 2007)
2. then click the excel options
3. then click the advance option
4. then there is one option (show sheets tab) under display option for this workbook.......you have to unticked that option.....
now your all sheets will not display to the user......
now user will go to another sheet through your first sheet with hyper link
Regards
CA Mahaveer Somani
then follow these steps:
1. click the microsoft office button (left top of the excel window in excel 2007)
2. then click the excel options
3. then click the advance option
4. then there is one option (show sheets tab) under display option for this workbook.......you have to unticked that option.....
now your all sheets will not display to the user......
now user will go to another sheet through your first sheet with hyper link
Regards
CA Mahaveer Somani
Surender1978
New Member
Thank you so much its really helped me.