ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect Data Filled Cells on Save Only (https://www.excelbanter.com/excel-discussion-misc-queries/157981-protect-data-filled-cells-save-only.html)

litty

Protect Data Filled Cells on Save Only
 
Is there a way to protect data filled cells when the user saves the
spreadsheet? I would like the user to have the opportunity to open the
spreadsheet, enter data in the empty cells, have the oportunity to go back to
the any of the data that was just added upon opening and change if needed,
and then have all cells with data in them locked when the user saves the
spreadsheet. Of course, when the user opens the spreadsheet again, I would
like all data filled cells to remain locked.



All times are GMT +1. The time now is 07:09 PM.

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