Relation between hide(orunhide) and protect
When I protect a worksheet via Tools, Protection, Protect Sheet and go to
Format, Sheet I find that Hide is not grayed out.
Protecting the workbook structure however does have this effect, as it
should.
--
Jim
"clara" wrote in message
...
| Hi all,
|
| What is the relation between hide(or unhide) and protect(or unprotect)? I
| can change a worksheet'visible through immediate window without
unprotecting
| a protected sheet,but why the hide or unhide submenu is grayed out when
the
| worksheet is protected.
|
| Clara
| --
| thank you so much for your help
|