If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
possible to default?: Format Comment > Alignment > Automatic Size
Rather than selecting the "Automatic Size" for each cell
comment ONE AT A TIME, is it possible to set your options so that all cell comments start out with the automatic size feature enabled? Thank you. |
#2
|
|||
|
|||
possible to default?: Format Comment > Alignment > Automatic Size
The change comments at one time with a macro
http://www.mvps.org/dmcritchie/excel...ent.htm#resize To catch comments and resize them when the workbook is opened see Stephen Bullen's reply in http://groups.google.com/groups?th=4e1723a41570510d --- 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 wrote in message ... Rather than selecting the "Automatic Size" for each cell comment ONE AT A TIME, is it possible to set your options so that all cell comments start out with the automatic size feature enabled? Thank you. |
#3
|
|||
|
|||
possible to default?: Format Comment > Alignment > Automatic Size
How about resizing them when you're done via a macro?
http://www.contextures.com/xlcomments03.html#Resize (From Debra Dalgeish's site) wrote: Rather than selecting the "Automatic Size" for each cell comment ONE AT A TIME, is it possible to set your options so that all cell comments start out with the automatic size feature enabled? Thank you. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing the default font size of comments? | David | Setting up and Configuration | 3 | April 13th, 2004 06:33 PM |
Default File Location | Derek Ruesch | Setting up and Configuration | 6 | January 30th, 2004 03:03 AM |
How to change Excel comment default font size? (for Office 2000) | Jason | Setting up and Configuration | 1 | December 24th, 2003 02:35 PM |
Changing default number format in worksheets | John deChadenedes | Worksheet Functions | 0 | October 9th, 2003 05:52 PM |
default (start-up) window size | fw | Setting up and Configuration | 0 | October 2nd, 2003 03:31 AM |