Have you ever tried to change the way comments appear in Excel ? you know, remove the username information, or change the background color, or even change the color of the comment indicator and have things *stay* that way ?
Well, I’ve heard that quite a few times, so I decided to build something to help. It’s a simple Add-In called ‘Comment Control’. It allows you to change the text that appears by default when you insert a comment (or don’t have text at all), change the font, the background color and the color of the comment indicator.
It works with a simple toggle button, so you can turn it on / off easily.
It will NOT affect existing comments, only new ones.
Here are some screen shots:
The toolbar with the toggle on:
The ‘Settings’ form:
And the result:
You can download it from here.
If you want to look at the code, the password is ‘a’ (No quotes). Tell me what you think !
Edit: Updated on 2/21/2005, no longer requires the comdlg32.ocx file to work.