| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comment box - fix size and location?
Using Excel 2003. Is there a way to fix the location and size of the comment
boxes so that they stay with the cell and do not change size? I have not found a way searching Help and Google. It appears that they have a party while the file is closed, moving themselves about and changing their box sizes randomly. Does this happen because new rows are inserted? If so, how un-helpful. Or is this a Special Feature of Excel, thrown in to keep us from getting all relaxed and self-confident? I know how to move and resize a comment box. I do not wish to do this each time I open each file. We can't use a macro. I have a feeling there is no easy solution, but thought I'd try you expert users. -- Grinny |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment box - fix size and location?
If you can't use a macro because the workbook can't contain macros, can you use
a macro in another workbook that resizes/resets the comments. If yes, visit Debra Dalgleish's site: http://contextures.com/xlcomments03.html#Reset http://contextures.com/xlcomments03.html#Resize If no, then never mind. grinny wrote: Using Excel 2003. Is there a way to fix the location and size of the comment boxes so that they stay with the cell and do not change size? I have not found a way searching Help and Google. It appears that they have a party while the file is closed, moving themselves about and changing their box sizes randomly. Does this happen because new rows are inserted? If so, how un-helpful. Or is this a Special Feature of Excel, thrown in to keep us from getting all relaxed and self-confident? I know how to move and resize a comment box. I do not wish to do this each time I open each file. We can't use a macro. I have a feeling there is no easy solution, but thought I'd try you expert users. -- Grinny -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment box - fix size and location?
Dave, thanks for reminding me to check Debra Dalgleish! I can use these
macros on worksheets that I don't have to share. But alas and shucks, guess I'll keep adjusting them one at a time in this book. -- Grinny "Dave Peterson" wrote: If you can't use a macro because the workbook can't contain macros, can you use a macro in another workbook that resizes/resets the comments. If yes, visit Debra Dalgleish's site: http://contextures.com/xlcomments03.html#Reset http://contextures.com/xlcomments03.html#Resize If no, then never mind. grinny wrote: Using Excel 2003. Is there a way to fix the location and size of the comment boxes so that they stay with the cell and do not change size? I have not found a way searching Help and Google. It appears that they have a party while the file is closed, moving themselves about and changing their box sizes randomly. Does this happen because new rows are inserted? If so, how un-helpful. Or is this a Special Feature of Excel, thrown in to keep us from getting all relaxed and self-confident? I know how to move and resize a comment box. I do not wish to do this each time I open each file. We can't use a macro. I have a feeling there is no easy solution, but thought I'd try you expert users. -- Grinny -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing location of comment when hovering over cell | Excel Discussion (Misc queries) | |||
| stablize the Excel comment boxes (size and location) | Excel Discussion (Misc queries) | |||
| How do I change the "comment" default location ? | Excel Worksheet Functions | |||
| Default comment location | Excel Worksheet Functions | |||
| is there a way to change the default location of an excel comment | Setting up and Configuration of Excel | |||
Linear Mode
