Using the subtotal function on a prtected sheet

S

Scottm

Can you use the subtotal funtion on a protected excel worksheet?
I need to protect my sheet but still be able to have those viewing it be
able to expand/collapse the sutotals. Can this be done?
Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use the subtotal function while a worksheet is protected? 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Doughnut Chart linked with the slicer in the pivot table 0
subtotal, match? 10
Protection using the subtotal function 1
Problem with SET & REF function 0
Import external data into Excel 2007 so I can subtotal it 2
Grouping on protected worksheets 4

Top