ExcelBanter - Using Sub-Total function in locked sheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using Sub-Total function in locked sheet? (https://www.excelbanter.com/excel-worksheet-functions/191896-using-sub-total-function-locked-sheet.html)

Don C.

Using Sub-Total function in locked sheet?

Excel 2003

I cannot get the worksheet to allow the use of the sub-total function in a
locked sheet. There is no box to check for this option in the "allow all
users of this worksheet to..." in the protection area.

Any suggestions?

All times are GMT +1. The time now is 09:00 AM.