View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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