VBA to REMOVE comment indicator triangles
I have seen various little ways of people overcoming the problem ..e.g vba to add autoshapes to cover them etc..
BUT does ANYONE know of a way to LITERALLY REMOVE the little red triangle indicators or at least change their colour to white or something?
thanks
You can do a combination of 2 things, a bit of code, and turning off comments and indicators, using Options -> advanced and then use the following code
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
thanks mate. perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks