Preventing formatting changes in a protected worksheet

S

Singh

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Excel Worksheet 1
Setting column width in a table with a macro is not working 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Allow users to edit ranges problem 2007 0
Prevent cut & paste in a protected worksheet. 0
Dynamic Protected Range? 1
Edit text format in non-protected cells in protected worksheet 2
Formatting and allow users to edit ranges (excel 2003) 0

Top