| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comment box size
For some reason, the size of the comment box changes over time - not sure
why. Some boxes seem to get bigger and some boxes shrink so that you cannot even read the text in them. Is there a way to 'lock' the comment box size so that it does not change? Thanks. Joe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment box size
I'm not sure you can control this, but you can reset them with a macro:
http://www.contextures.com/xlcomments03.html#Resize from Debra Dalgleish's site. JoeP wrote: For some reason, the size of the comment box changes over time - not sure why. Some boxes seem to get bigger and some boxes shrink so that you cannot even read the text in them. Is there a way to 'lock' the comment box size so that it does not change? Thanks. Joe -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment box size
Dave,
Thanks for the help. The macro debugs at the line ..Shape.TextFrame.AutoSize = True Any idea why? Joe "Dave Peterson" wrote: I'm not sure you can control this, but you can reset them with a macro: http://www.contextures.com/xlcomments03.html#Resize from Debra Dalgleish's site. JoeP wrote: For some reason, the size of the comment box changes over time - not sure why. Some boxes seem to get bigger and some boxes shrink so that you cannot even read the text in them. Is there a way to 'lock' the comment box size so that it does not change? Thanks. Joe -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment box size
Is the worksheet protected?
JoeP wrote: Dave, Thanks for the help. The macro debugs at the line .Shape.TextFrame.AutoSize = True Any idea why? Joe "Dave Peterson" wrote: I'm not sure you can control this, but you can reset them with a macro: http://www.contextures.com/xlcomments03.html#Resize from Debra Dalgleish's site. JoeP wrote: For some reason, the size of the comment box changes over time - not sure why. Some boxes seem to get bigger and some boxes shrink so that you cannot even read the text in them. Is there a way to 'lock' the comment box size so that it does not change? Thanks. Joe -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Size of comment box in xml stored spreadsheet becoming small | Excel Discussion (Misc queries) | |||
| setting standard comment size for all rows in a worksheet. | Excel Discussion (Misc queries) | |||
| Need feature to change font size default in COMMENT boxes. | Excel Discussion (Misc queries) | |||
| Comment size | Excel Discussion (Misc queries) | |||
| Comment window size | Excel Discussion (Misc queries) | |||
Linear Mode
