ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to change font for all existing comments at once? (https://www.excelbanter.com/excel-worksheet-functions/75746-how-change-font-all-existing-comments-once.html)

robynkedwards

how to change font for all existing comments at once?
 
i need to change the font on all existing comments in the entire workbook.
i'd like to do it all at one time, rather than one at a time. thank you.

David McRitchie

how to change font for all existing comments at once?
 
Debra Dalgleish has pages on cell comments that would answer your question
http://www.contextures.com/tiptech.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"robynkedwards" wrote...
i need to change the font on all existing comments in the entire workbook.
i'd like to do it all at one time, rather than one at a time. thank you.





All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com