Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center Comments on Center of Screen
I am setting up a workbook and the comments are actually pictures instead of
text. I was wondering if there is some way to set it up so that the pictures (comments) show up in the middle of the screen (or at least show fully in the screen) regardless of where the cell is at on screen. For example, I want the comment to be fully visible on screen whether the cell is at the extreme high end or low end of the visible worksheet. Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center Comments on Center of Screen
See code at Debra Dalgleish's site.
http://www.contextures.on.ca/xlcomments03.html#Centre Gord Dibben MS Excel MVP On Fri, 11 Sep 2009 18:23:01 -0700, Raymond W. <Raymond wrote: I am setting up a workbook and the comments are actually pictures instead of text. I was wondering if there is some way to set it up so that the pictures (comments) show up in the middle of the screen (or at least show fully in the screen) regardless of where the cell is at on screen. For example, I want the comment to be fully visible on screen whether the cell is at the extreme high end or low end of the visible worksheet. Any help is greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center Comments on Center of Screen
Thank you, that certainly seems to accomplish the goal. I have never used VBA
or macros to accomplish what I needed in Excel, so now I will educate myself. Thanks =) "Gord Dibben" wrote: See code at Debra Dalgleish's site. http://www.contextures.on.ca/xlcomments03.html#Centre Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center Comments on Center of Screen
Thanks for the feedback.
VBA and macros are extremely useful. Good idea to delve into them. Gord On Sat, 12 Sep 2009 13:38:01 -0700, Raymond W. wrote: Thank you, that certainly seems to accomplish the goal. I have never used VBA or macros to accomplish what I needed in Excel, so now I will educate myself. Thanks =) "Gord Dibben" wrote: See code at Debra Dalgleish's site. http://www.contextures.on.ca/xlcomments03.html#Centre Gord Dibben MS Excel MVP |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center Comments on Center of Screen
I just wanted to respond one last time and say thanks! I actually got
everything working today. I was having a little problem at first figuring a bit out, but then it all clicked into place. Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center Comments on Center of Screen
Good to hear.
Thanks for the feedback. Gord On Mon, 14 Sep 2009 17:10:01 -0700, Raymond W. wrote: I just wanted to respond one last time and say thanks! I actually got everything working today. I was having a little problem at first figuring a bit out, but then it all clicked into place. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge and Center and Center Accross Selection | New Users to Excel | |||
Making comments appear in the center of the screen. | Excel Discussion (Misc queries) | |||
center across the selection | New Users to Excel | |||
How do i center a worksheet in the view screen | Excel Discussion (Misc queries) | |||
Center Across Selection Vertically Help. I am trying to center te. | Excel Discussion (Misc queries) |