Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comment Box Positioning Q | Excel Worksheet Functions | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
What is the deal with Comment Object Positioning? | Excel Discussion (Misc queries) | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
positioning a comment | Excel Programming |