Sounds like you are getting caught up chasing ghosts without knowing what's happening! Do you know how to debug? Go to the first line in code Application.ScreenUpdating = False and put the cursor there. Then push F9, this will put a breakpoint in and highlight the line brown. What happens is you can execute the code 1 line at a time and trace exactly whats happening, pretty good right? Now change something on your sheet and the code window should pop up with the first line highlighted. At this point you can use F8 to step through the code, executing line by line to see what is changing and when.
To answer one of your questions: No, changing a cells colour does not set off the change event, its only when you change data in a cell (or many cells).
The other thing is, you could set it up so that it doesn't protect for 2 people as well with:
The protection can be weird in MS Excel sometimes, I have recently found a MS Excel bug where Worksheet.Protect doesn't work when the workbook is closing... but as it takes $249 USD to report a bug to Microsoft, I won't be reporting it!
Bookmarks