| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Comment box size
Is there a way to control the size of the comment box. Currently the box
opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle. I know that can be adjusted by using the handles...but can the rectancle size be set as a default? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comment box size
Hi
I'd try a macro from Debra Dalgleish's site: http://contextures.com/xlcomments03.html#Resize If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm "pcor" wrote: Is there a way to control the size of the comment box. Currently the box opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle. I know that can be adjusted by using the handles...but can the rectancle size be set as a default? Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comment box size
Many thanks that was real good advice and also thank to Debra for providing such good help "Eduardo" wrote: Hi I'd try a macro from Debra Dalgleish's site: http://contextures.com/xlcomments03.html#Resize If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm "pcor" wrote: Is there a way to control the size of the comment box. Currently the box opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle. I know that can be adjusted by using the handles...but can the rectancle size be set as a default? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i reformat text size in all comment boxs to a default size | Excel Worksheet Functions | |||
| Increasing comment box size? | Excel Discussion (Misc queries) | |||
| Comment box size | Excel Discussion (Misc queries) | |||
| How do I re-size a comment box using VBA? | Excel Discussion (Misc queries) | |||
| Comment size | Excel Discussion (Misc queries) | |||
Linear Mode
