Center Comments on Center of Screen

R

Raymond W.

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.
 
R

Raymond W.

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 =)
 
G

Gord Dibben

Thanks for the feedback.

VBA and macros are extremely useful.

Good idea to delve into them.


Gord
 
R

Raymond W.

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top