When i lock cells in excel How can i prevent users from editing the background color, text color, bold text etc in cells that are locked. But allow them to change background color etc in cells that are not locked?
When i protect the sheet all cells become uneditable regarding formatting.
Thanks in advance.
Worksheet_Change
event to revert the cells you want to lock to their original formatting.