I have to say I'm not good at this, I have manged to get a code that changes the colour of the cells according to what's in them! Easy stuff no doubt but took me ages!
The problem is that a lot of the cells need to be hidden and or protected as many people use this and I don't want certain cells to be changed, but when I protect these cells, the code doesn't work.
I have read a number of posts which says to do the following
Add the line:
at the beginning of the code to unprotect the sheet (change the password as desired) and then add the line:
At the end of the code to reprotect it when it is done.
But when I do this I get an error (runtime 1004 I think) and I feel like I have tried everything! I know this is probably a really easy one for you, but I'm lost!
I know that similar q's have been asked, but I can't seem to make that code work without an error!
Hoping someone canhelp