• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comments Indicator

Good day manoj_th


The short answer is no. If the colour really gets to you you could after inserting comments draw a triangle over the comment arrow head and fill with your colour, and do this for all comments!! not the best way. There are different VBA code to do this but most authors pin a warning to the code so if you want to Google it and install then that's up to you. You could do it by changing system colour settings, try the link...


http://excel.tips.net/T003930_Changing_the_Comment_Color.html
 
Hi,

Thanks for the reply, but i am looking is there any other solution without changing the system settings.


Thanks

Manoj
 
Hi Manoj,


Can you please download the below file..


http://dl.dropbox.com/u/78831150/Excel/Comment%20Indicator%20Changer.xlsm


Courtesy : https://groups.google.com/forum/?hl=en&fromgroups=#!topic/microsoft.public.excel.programming/mSnOzRDy6Rk


Its not exactly what you want.. may be you are searching in Excel option, and then.. a color chooser pallet and then select the color.. for Error Indicator


Sorry but.. Redmond Guys missed it.. :)


Regards,

Deb
 
There you go manoj_th VBA code,......but I must say that when you look at some of the codes on the various forum sites Debraj Roys looks more up to the job (neater).
 
Hi


Interesting question - and one I had never considered.


http://www.contextures.com/xlcomments03.html#Indicator


... has an alternative to number the comments with a rectangular box and inset number.


Glen
 
You must log in or register to reply here.
Back
Top