Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving, Resizing a Cell Comment
Debra Dalgleish has tons of sample code:
http://contextures.com/xlcomments03.html maybe even: http://contextures.com/xlcomments03.html#Reset Perico wrote: I succeeded in iterating through a named range to insert comments and change their font size. But I can't figure out how to move the comment frame or resize it. The comment extends on one line off to the right and cannot be seen completely. I can't use autosize b/c that just gives me one long comment off the screen. When I implement recorded macro code to do this, I get error messages, "not supported". (I understand the height / width properties are relative to current position.) How can I either reposition the comment textframe or resize it, without using the autosize method, and avoid error messages? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving and resizing the file window | Excel Discussion (Misc queries) | |||
resizing and moving chart elements | Charts and Charting in Excel | |||
Resizing Comment Box | Excel Programming | |||
Resizing Comment boxes back to default size! | Excel Programming | |||
Resizing comment boxes | Excel Programming |