protect unhide worksheet VBA

[Rungravee Boonsud]

Hi everyone,

I want to protect sheet, cannot unhide sheet or set password for unhide sheet (only specific sheet)

anyone who can know code in VBA


Thank you in advance for your respond

 

[Domenic]

I'm not sure I understand. If you want to completely hide a worksheet from the user so that he or she has no access to it and cannot make it visible, you can set the Visible property for the worksheet to xlSheetVeryHidden...

Worksheets("Sheet1").Visible = xlSheetVeryHidden

Hope this helps!