Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments boxes resizing
This may sound like a stupid problem and could be operator error, but when I
insert and/or move cells, the comments boxes resize themselves. For example, when I cut a row and insert it elsewhere, the comment stays associated with the cell, but when I roll over the cell, the comment box is still located in the general vicinity of where it was AND most of the time has shrunk so small that it is one letter wide or has almost completely disappeared-- they only way I even know where it is the now really long lead arrow. Is there a way to keep this from happening (and therefore making me go through and resize them all everytime I insert a new row)? I keep working on this spreadsheet and moving stuff around (trying to get it just right for the big boss whose instructions often change and were ambiguous to begin with!). Even once it's nailed down, I will continue to add more rows as we add information. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments boxes resizing
Comments seem to have a mind of their own.
The closest thing I know to control them is to just use a macro that resets them back to where they belong. Debra Dalgleish has some code to reset/resize them he http://contextures.com/xlcomments03.html#Reset http://contextures.com/xlcomments03.html#Resize If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm HeatherBelle wrote: This may sound like a stupid problem and could be operator error, but when I insert and/or move cells, the comments boxes resize themselves. For example, when I cut a row and insert it elsewhere, the comment stays associated with the cell, but when I roll over the cell, the comment box is still located in the general vicinity of where it was AND most of the time has shrunk so small that it is one letter wide or has almost completely disappeared-- they only way I even know where it is the now really long lead arrow. Is there a way to keep this from happening (and therefore making me go through and resize them all everytime I insert a new row)? I keep working on this spreadsheet and moving stuff around (trying to get it just right for the big boss whose instructions often change and were ambiguous to begin with!). Even once it's nailed down, I will continue to add more rows as we add information. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments boxes resizing
Awesome! I've never done macros before, but they seem to work-- I do remember
from a class I took a couple of weeks ago that you can set a macro to run when you hit a shortcut key, so I'm now in the process of trying to remember how to get that to work :) Thanks so much!! "Dave Peterson" wrote: Comments seem to have a mind of their own. The closest thing I know to control them is to just use a macro that resets them back to where they belong. Debra Dalgleish has some code to reset/resize them he http://contextures.com/xlcomments03.html#Reset http://contextures.com/xlcomments03.html#Resize If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm HeatherBelle wrote: This may sound like a stupid problem and could be operator error, but when I insert and/or move cells, the comments boxes resize themselves. For example, when I cut a row and insert it elsewhere, the comment stays associated with the cell, but when I roll over the cell, the comment box is still located in the general vicinity of where it was AND most of the time has shrunk so small that it is one letter wide or has almost completely disappeared-- they only way I even know where it is the now really long lead arrow. Is there a way to keep this from happening (and therefore making me go through and resize them all everytime I insert a new row)? I keep working on this spreadsheet and moving stuff around (trying to get it just right for the big boss whose instructions often change and were ambiguous to begin with!). Even once it's nailed down, I will continue to add more rows as we add information. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments boxes resizing
In xl2003 menus:
Tools|macro|macros Select the macro you want Options button and assign it a shortcut key HeatherBelle wrote: Awesome! I've never done macros before, but they seem to work-- I do remember from a class I took a couple of weeks ago that you can set a macro to run when you hit a shortcut key, so I'm now in the process of trying to remember how to get that to work :) Thanks so much!! "Dave Peterson" wrote: Comments seem to have a mind of their own. The closest thing I know to control them is to just use a macro that resets them back to where they belong. Debra Dalgleish has some code to reset/resize them he http://contextures.com/xlcomments03.html#Reset http://contextures.com/xlcomments03.html#Resize If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm HeatherBelle wrote: This may sound like a stupid problem and could be operator error, but when I insert and/or move cells, the comments boxes resize themselves. For example, when I cut a row and insert it elsewhere, the comment stays associated with the cell, but when I roll over the cell, the comment box is still located in the general vicinity of where it was AND most of the time has shrunk so small that it is one letter wide or has almost completely disappeared-- they only way I even know where it is the now really long lead arrow. Is there a way to keep this from happening (and therefore making me go through and resize them all everytime I insert a new row)? I keep working on this spreadsheet and moving stuff around (trying to get it just right for the big boss whose instructions often change and were ambiguous to begin with!). Even once it's nailed down, I will continue to add more rows as we add information. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing Comments in Excel | Excel Discussion (Misc queries) | |||
Excel 2003 - Comments box - automatic resizing | Excel Discussion (Misc queries) | |||
Resizing Comments | Excel Discussion (Misc queries) | |||
Comments Boxes | Excel Discussion (Misc queries) | |||
Resizing "comments" boxes in a workbook all at once | Excel Discussion (Misc queries) |