How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows, Insert Rows, and Sort. However, when the user opens the file, it will not allow the allowed functions that I have allowed.
April 3, 2009 2:43 PM
April 3, 2009 2:52 PM