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

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