Can i protect the hidden sheet ?

[qarbiq]

I have a hidden sheet that is being used as a sample. IT SHOULD ALWAYS stay hidden, is there a way to KEEP IT HIDDEN so users can not unhide it ? If they unhide my VBA codes my not work.

I do not want to use protect sheet option since it closes everything . I only need to keep it hidden all the time and no one can unhide it to protect it from the excel gets messed up


Please someone help me i am new to VBA

Thanks

 

[dispelthemyth]

use

Worksheets("Sheet1").Visible = xlVeryHidden then put a password on your VBA

ALT + F11 then Tools --> VBAProject properties --> Protection


This can be cracked if someones wants but its good for passive users

I have a hidden sheet that is being used as a sample. IT SHOULD ALWAYS stay hidden, is there a way to KEEP IT HIDDEN so users can not unhide it ? If they unhide my VBA codes my not work.

I do not want to use protect sheet option since it closes everything . I only need to keep it hidden all the time and no one can unhide it to protect it from the excel gets messed up


Please someone help me i am new to VBA

Thanks

 

[dispelthemyth]

So on your last post which i assume this is for, replace the instances of

Sheets(Sheets.Count).Visible = xlHidden

with

Sheets(Sheets.Count).Visible = xlveryHidden

 

[qarbiq]

YESSSS. Thank you so much . You are Greatttttt. Thanks again