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