MS Excel / VBA help thread

You are reading a single comment by @aggi 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.

•

.Rodders in reply to @aggi

Hey aggi - just seen this, didnt get a notification for some reason. Thought I had got around it by locking only certain parts but having just looked through its all gone to pot anyway! Yes I think it will be easier to just keep everyone else locked out from now on in...

About

@aggi started