View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dave m dave m is offline
external usenet poster
 
Posts: 7
Default Sheet protection

do you mean you need more information on how to do this?


"pmss" wrote:

thanks but i could not get your post properly.


"dave m" wrote:

If you add the protection for sheet and check the box that allows all users
to " Format Rows" and/or "Format Columns" then your checkbox will work.
All Cells on the sheet will still be protected.

Dave


"pmss" wrote:

Hello

I am using checkbox (from control toolbox) to hide and unhide some rows in
the sheet. I want to protect this sheet with password but Checkbox should
work properly after protecting the sheet.

Thanks