ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell format protection (https://www.excelbanter.com/excel-discussion-misc-queries/58811-cell-format-protection.html)

gary

Cell format protection
 
I have certain cells locked in a protected worksheet. The spreadsheet is
used by others who input data in unlocked cells and return to me. My
problem is that when they copy & paste something, they are eliminating the
formats I have all ready set (border, allow numbers only, etc.). Is there
any way to prevent this, while still maintaining the protection of the rest
of the locked cells?


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

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