Hyperlink and Hide / Unhide sheet

[ateebali]

Dear Sir
I have a worksheet which has following sheets;
Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6

All these sheets have buttons "back" and "next"
I have hyperlinked this to next and back sheet but what it want is that;
Once I press "Next" on sheet 1, user jumped to Sheet2 via hyperlink, at same time, Sheet 1, Sheet3-4-5-6 should be hidden
So we can only work on active sheet

If click back button on sheet2, it will back to us on sheet1 and rest of sheets are now hidden
so one sheet one time

 

[Jaafar Tribak]

I am confused . Are you clicking on buttons or hyperlinks ?

 

[ateebali]

I am clicking buttons but make hyperlink to that buttons
I dont know the way to attach file, otherwise could have attached sample file.

 

[ateebali]

The buttons are shape button from Drawing Tools

 

[My Aswer Is This]

If your using Shapes as buttons. Why do you need Hyperlinks.

Tell me how you have linked a Button to a Hyperlink

You said:

I have hyperlinked this to next and back sheet but what it want is that;​

 

[ateebali]

Dear Sir
Actually here, no option to upload file, thats why I cross post now at following link;

https://chandoo.org/forum/threads/cross-post-hyperlink-and-hide-unhide-sheet.40561/

 

[ateebali]

This is solved, see this link.
thanks everyone
https://chandoo.org/forum/threads/cr...e-sheet.40561/