hidden sheet shouldn't be viewed by others.

[DATTATREYA]

Hi,
when the sheet is hidden by me in the excel others shouldn't unhide the hidden sheet. Can any of you help me in getting the coding for this.

Thanks in advance
Regards
Datta

 

[prajul89]

Activesheet.visible = xlveryhidden

This code will not allow user to unhide Sheet.

HOH

 

[storm8]

Sheets(1).Visible = xlVeryHidden

you can make this sheet visible again only with vba.

 

[flakedew]

how to make it visible again by the creator

 

[prajul89]

Sheets(1).Visible = xlVeryHidden

you can make this sheet visible again only with vba.

Yes. Only VBA and no other method.

 

[inarbeth]

You don't even need to run a macro. Go into VBE (Alt+F11), Properties window (F4 to make it appear if it is hidden). Select the sheet and then in the Visible property, select 2 - xlSheetVeryHidden.