Resizing comments

[adamjohnson182]

I have a large spreadsheet with a few dozen tabs, and on each tab, the comments default to an absurdly small font and box size, causing me to have to resize each one individually. Is there a way to fix this so that I don't have to do this individually every time?

[Thalassa]

Try this

Please Login or Register  to view this content.

[adamjohnson182]

That doesn't seem to work on the worksheets already in the workbook, but does work if I create a new tab.

[Thalassa]

Sorry, I missed the every worksheet bit. Try this

Please Login or Register  to view this content.

[adamjohnson182]

That still doesn't seem to be working for new comments. Sorry, I think maybe that part wasn't clear from my original post.

[Thalassa]

Sorry, I dont know a way to automatically size comments. You may find something here http://www.contextures.com/tiptech.html

[adamjohnson182]

This seems to be the best way to do it, although it makes the tool tips on my taskbar much larger in proportion.
http://j-walk.com/ss/excel/usertips/tip075.htm