Formatting unlocked cells and stop users from pasting

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

There are multiple users that need to update a work*** that I have
protected so I need to ensure that they are restricted from inserting/
deleting cells or makig major formatting changes (the cells are
unlocked though for them to make their changes directly).

But we still require the majority of the user's to make one formating
change, which is to change applicable text to red in any cells of the
spread***. Does anyone know a VBA code I can add to my code to
permit users without full access to do so.

Also, is there a way to prevent users from pasting over protected
unlocked cells. As many of the users are overwriting formulas and
formatting when they do so.

Your help will be appreciated!!

.

Quantcast