Macro Code In A Different Color

[nebb]

Macro code is normally black on white. When I make changes to the code, I would like to highlight the changed code in a different color. Is there a way of doing this?

[davesexcel]

in vba try going to tools options editor format
you will have to select the text you want to change though,

[nebb]

Thanks Davesexcel but unless I'm missing something, none of the 'editor format' options gives me what I want. The 'selection text' option shows a different color only when the text is selected. I would like to be able to change the text color of certain instructions and see it even when the text is not selected.