Sheets hidden manually or hidden with a macro can still be unhidden, password
protecting the hidden sheet might make this harder, but still.

Now a macro that hides a worksheet using the xlVeryHidden flag cannot be
unhidden manually in any way. It can only be unhidden with another macro.

sub HideSheet1()
Sheets("Sheet1").Visible = xlVeryHidden
end sub

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Mike" wrote:

Is there a way to prevent a user from deleting a given WorkSheet? Also, is
there a way to prevent the user from "UnHiding" a WorkSheet??

Thanks