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.
Posted by Aladin Akyurek on December 11, 2001 11:02 AM
Frozen Panes & Comments... No idea
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
========
Posted by Jack on December 12, 2001 11:57 AM
Try this works for me, maybe you to as a work arround
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??
Posted by Aladin Akyurek on December 13, 2001 11:06 AM
Re: Try this works for me, maybe you to as a work arround
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
