0

Locking the Spreadsheet

Hello,

One more question - I am trying to lock my spreadsheet so formulas cannot be keyed over. When I lock all cells containing formulas using native excel protection and then lock the sheet with auto+hide+lock in A1 - I run the report and cannot apply a filter. This happens even though when I protect the sheet using native excel protection I allow the user to autofilter.

Thanks again for taking the time to respond.

Tom

0 comments

Please sign in to leave a comment.