View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wayne
 
Posts: n/a
Default Using subtotaling and protecting a sheet at the same time

I have a worksheet that is protected that has places for data entry that
works fine. It also has subtotaling to outline the sheet. Is there a way to
make the subtotal function work on a protected sheet. I have it running
currently thru a macro.

Thanks
Wayne