Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default comment positioning

Hi,

I realise this as been asked before just hoping that there may have
been some changes or news ;o) if not is there a place to post comments
to MS so that maybe one day it will change.

Anyway the question:
Is it possible to position comments to
specific locations even when only viewing with mouse over ?

Rodney

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default comment positioning

See:


http://groups.google.com/group/micro...d8bf0e972d8391


--
Gary's Student


"Rodney63" wrote:

Hi,

I realise this as been asked before just hoping that there may have
been some changes or news ;o) if not is there a place to post comments
to MS so that maybe one day it will change.

Anyway the question:
Is it possible to position comments to
specific locations even when only viewing with mouse over ?

Rodney


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default comment positioning

Thanks for the link Gary,
interesting but it still falls flat because of no mouseOver event, its
always on when you run the macro ?

I found a mouseOver Event & much more in the Microsoft Script Editor
but unfortunately any changes made seem to reset themselves ? anyone
have any ideas ?

here is some code from the MSE:
<div style='mso-element:comment'<![if !supportAnnotations]

<div id="_com_1" class=msocomtxt
onmouseover="msoCommentShow('_com_1','_anchor_1')"
onmouseout="msoCommentHide('_com_1')" language=JavaScript<![endif]

<div<![if !supportAnnotations]<a class=msocomhide
href="#_msoanchor_1"
name="_msocom_1"[1]</a<![endif]<!--[if gte mso 9]<xml
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202"
path="m,l,21600r21600,l21600,xe"
<v:stroke joinstyle="miter"/
<v:path gradientshapeok="t" o:connecttype="rect"/
</v:shapetype<v:shape id="_x0000_s1025" type="#_x0000_t202"
style='position:absolute;

margin-left:240pt;margin-top:154.5pt;width:96pt;height:55.5pt;z-index:1;
visibility:hidden' fillcolor="infoBackground [80]"
o:insetmode="auto"
<v:fill color2="infoBackground [80]"/
<v:shadow on="t" color="black" obscured="t"/
<v:path o:connecttype="none"/
<v:textbox style='mso-direction-alt:auto'/
<x:ClientData ObjectType="Note"
<x:MoveWithCells/
<x:SizeWithCells/
<x:AutoFillFalse</x:AutoFill
<x:Row1</x:Row
<x:Column1</x:Column
<x:AuthorComment</x:Author
</x:ClientData
</v:shape</xml<![endif]--<![if !vml]<span
style='mso-ignovglayout'<![endif]

also a style sheet for the comment, how nice it would be to simply
change colour of your anchors ?

if (msoBrowserCheck()) {
document.styleSheets.dynCom.addRule(".msocomspan1" ,"position:absolute");
document.styleSheets.dynCom.addRule(".msocomspan2" ,"position:absolute");
document.styleSheets.dynCom.addRule(".msocomspan2" ,"left:-1.5ex");
document.styleSheets.dynCom.addRule(".msocomspan2" ,"width:2ex");
document.styleSheets.dynCom.addRule(".msocomspan2" ,"height:0.5em");
document.styleSheets.dynCom.addRule(".msocomanch", "font-size:0.5em");
document.styleSheets.dynCom.addRule(".msocomanch", "color:red");
document.styleSheets.dynCom.addRule(".msocomhide", "display: none");
document.styleSheets.dynCom.addRule(".msocomtxt"," visibility: hidden");
document.styleSheets.dynCom.addRule(".msocomtxt"," position: absolute");

document.styleSheets.dynCom.addRule(".msocomtxt"," top:-10000");

document.styleSheets.dynCom.addRule(".msocomtxt"," left:-10000");

document.styleSheets.dynCom.addRule(".msocomtxt"," width: 33%");

document.styleSheets.dynCom.addRule(".msocomtxt"," background:
infobackground");
document.styleSheets.dynCom.addRule(".msocomtxt"," color: infotext");
document.styleSheets.dynCom.addRule(".msocomtxt"," border-top: 1pt solid
threedlightshadow");
document.styleSheets.dynCom.addRule(".msocomtxt"," border-right: 2pt
solid threedshadow");
document.styleSheets.dynCom.addRule(".msocomtxt"," border-bottom: 2pt
solid threedshadow");
document.styleSheets.dynCom.addRule(".msocomtxt"," border-left: 1pt
solid threedlightshadow");
document.styleSheets.dynCom.addRule(".msocomtxt"," padding: 3pt 3pt 3pt
3pt");
document.styleSheets.dynCom.addRule(".msocomtxt"," z-index: 100");
}

Gary''s Student wrote:
See:


http://groups.google.com/group/micro...d8bf0e972d8391


--
Gary's Student


"Rodney63" wrote:

Hi,

I realise this as been asked before just hoping that there may have
been some changes or news ;o) if not is there a place to post comments
to MS so that maybe one day it will change.

Anyway the question:
Is it possible to position comments to
specific locations even when only viewing with mouse over ?

Rodney



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comment Box Positioning Q Sean Excel Worksheet Functions 1 March 17th 07 05:03 PM
How can I edit a comment w/o first having to select Show Comment Mary Ann Excel Discussion (Misc queries) 1 August 26th 05 12:34 AM
What is the deal with Comment Object Positioning? Mark Excel Discussion (Misc queries) 3 June 9th 05 11:05 PM
a comment plugin & copy paste directly from excel to comment ? fr. RFM Excel Worksheet Functions 0 December 1st 04 11:29 PM
positioning a comment Sheldon Excel Programming 0 September 30th 04 04:43 PM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"