Little help with Microsoft Excel, please

[lazarus]

I've got 20 pages on this spreadsheet, adding more. Each page has 15-20 comments. I'd like to change the default formatting on the comments, and have it different for each page. Heck, even the same for all pages, but different from the default, would be fine.

Is there a way to do that with Excel '03?

[LearnedHand]

1. No way to do it in Excel 2003 for all comments at once, but

you can script Windows to do it. See this blog entry:

http://excel.tips.net/Pages/T002974_Setting_the_Default_Font_Size_for_Comment_Balloons.html

[lazarus]

2. okay, thanks

I was hoping. Now I get to go through and do it one by one....

[Richardo]

3. You might try selecting all the tabs at once and make a universal change...

...Left click the first tab; shift-click the last one and all the worksheets will be selected, then you can make the font/size changes you want. Of course the font/size you select will be applied to everything on the sheet. That's the end of my great ideas. :shrug:

[lazarus]

4. yeah, it won't work on the comments

I'm mostly trying to change the width of the comment and the background colour of the comment. I also tried shift-selecting the cells the comments are in, and editing comments that way, but it won't work on multiple comments at a time.