How to linked with a hidden cell and sheets will hide when come to common sheet

[hasankabir375]

I want your kind help again if you could.
I need some condition to solve through Excel e.g
1-I need to open two common sheet and hide other sheets
2-From common 2 sheet there will some red color cell which will be linked to hidden sheets cell. Not only the sheet even the cell which I want to go. So the condition is clicking the linked cell will show the linked cell of hidden sheet.
3-When I come back the common sheet other hidden sheets will be hidden automatically.
I am totally unfamiliar with vba. I want to do the tasks with many cell. Could any help me?

 

[Yongle]

Q!1 Are the other sheets protected?
Q2 How are cells hidden in other sheets?
- Manually by user?
- or by VBA?

 

[hasankabir375]

1- Cell will not hidden. Sheets will hidden. So when I will click the hyperlinked of common sheet from which, when I click the link hidden sheet will be un hide and the cell of the hidden sheet will be pointed directly because the hidden sheets are descriptive of common sheets. So some sheets will hidden, when I clicked the hyperlinked/button cell respective hidden sheet will be opened to linked cell respectively. Again when come back to common sheet unshide sheet will be hide automatically. If I could the excel file will upload.

 

[hasankabir375]

I can't hidden file linked by only hyperlink without vba..

 

[Yongle]

Are any of the sheets protected?

 

[Yongle]

How were the links created?
- by formula =HYPERLINK( ...) ?
- by right click / hyperlink ... ?