MS Excel / VBA help thread

You are reading a single comment by @.Rodders and its replies. Click here to read the full conversation.

•

.Rodders

Any way of locking conditional formatting? Data to be received for different projects at different times - trying to protect against copy and pasting

•

aggi in reply to @.Rodders

Is it you entering the stuff or other people who are going to break it?

The only solution I found to this was a macro which re-applied the conditional formatting each time an edit was made. Not very elegant but seems to be the only option if you can't get people to paste values.

About

Avatar for .Rodders @.Rodders started