Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default autofit contents for comments in excel 2007
Hi,
Anyone know how to specify the content for a comment and then say "make it autofit the content" before it is revealed. I have had success adding the comment, specifying the text whilst it is invisible but you can't specify the size until you've shown it which means it has to start at the default size and then be resized whereas i want it to appear first of all the the correct size (which is ascertained by autofitiing the contents). I gues if I could set the default sixe for all comments on adding them to be tiny then i can do the resizing which would be an OK compromise if it's impossible to set the size prior to displaying. Thanks and regards, Mark PS As per Ron De Bruin's tutorial on the slowness of selecting and then manipulationg I want to address the comment 'direct' rather than selecting it first |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Autofit | Excel Discussion (Misc queries) | |||
how do i change default font for comments in excel 2007? | Excel Discussion (Misc queries) | |||
Autofit Comments | Excel Programming | |||
Comments autofit | Excel Programming | |||
Comments autofit | Excel Programming |