ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Preventing formatting changes in a protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/174970-preventing-formatting-changes-protected-worksheet.html)

Singh

Preventing formatting changes in a protected worksheet
 
Using the Tools -- Protection -- Allow Users to Edit Ranges function, I can
prevent users from manually changing the formatting of cells I allow them to
edit.

However, if the user copy/pastes a cell into one of these editable cells,
the formatting changes accordingly. Is there any way to prevent this (i.e.
allow "paste values" only)?


All times are GMT +1. The time now is 10:22 PM.

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