Hi,

I have a workbook that contains three worksheets but i have hidden on
worksheet (Sheet2) but i m retrieving data into sheet1 by formula,
this workbook goes to other users too and they can just click on Sheet
TAB and enable that sheet's visibility and see what the data is?

So my question is that how i can disable this right click on SHEET
TAB

OR

How can i protect this option by password like excel is providing this
facility for the whole sheet and workbook but if i only want to
protect this then how?

I saw that option which is in VBA PROJECT PROTIES but it doesn't work.

Kindly tell me step by step or provide me any example sheet or video.


I will be thankful to you.


Thanks
Husnain

NOTE: email me at