So, I'm having an issue and from the research I've done, I don't think there is solution but I will pose the question to the experts here!
I have a workbook that I have password protected each sheet. I also have the code below integrated on one sheet that triggers a name change and color...