Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Aladin - Comments Help

Posted by Duncan on December 11, 2001 4:54 AM
The commenting in excel is really useful, however I have a problem with it.
I have a comment in cell C6 and the panes frozen after column C. I would like the comment to appear when rolling the mouse over this visble cell even when column D is hidden due to the frozen panes. Excel just seems to display the comment 1 cell to the right.
Editing the comment (& moving it) just seems to move it when it is shown not when displayed with the mouse.

Hope that makes sense and you can solve it!
Thanks
D.


Frozen Panes & Comments... No idea

Posted by Aladin Akyurek on December 11, 2001 11:02 AM
Duncan --

> The commenting in excel is really useful, however I have a problem with it.

Yeah, it is. I could also replicate the problem you describe. I'm sorry I've no idea how that behavior can be corrected.

Cheers,

Aladin

========


Try this works for me, maybe you to as a work arround

Posted by Jack on December 12, 2001 11:57 AM

Hi guys, well thisis a little and a bit kinda top secret, i use A1 B1 C1 and so on as ref cells for junk or notes or formuilas and so on, why not use A1 as notes and note the real cell, and add in a cooment box attached to A1

H56 - Data of bank acct
I6 - Notes to give Aladin
F2 - Must Email Jack
OK not perfact but mouse ove A1 and ALL notes are there, just like i use bottom of data sheets for all my formula i have ever used i have hundreds of them, and i even comment the formula and VBS scripts, this way i have reference to my work all over the place and i can not loos it or not find it.

This idea i hit on as a work arroud, i suggest you adapt it to your needs but copy and past onto one comment box helps.

What do you think??


Re: Try this works for me, maybe you to as a work arround

Posted by Aladin Akyurek on December 13, 2001 11:06 AM

Jack --

Sounds good. If I'm not lazy, I use a separate worksheet to document the model that the workbook encompasses. At times though, one needs to have a comment in some cell of particular interest. Then having the problem Duncan describes is annoying.

Regards,

Aladin


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.