ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to allow sorting in a protected worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/225201-how-allow-sorting-protected-worksheet.html)

curtc.[_2_]

How to allow sorting in a protected worksheet?
 
I have several worksheets with lookup formulas in most of the cells. Is their
a way to allow the resulting row data to be sorted? I want to protect the
worksheet from changes/deletions to the original formulas, and only allow for
the sorting of the data that is generated. Thank You.


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com