Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Active chart screen visible coordinates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RLang - 20 May 2008 16:14 GMT
Hi,
  Is there a way to programmatically determine the starting or ending
visible portion of an embedded active chart in twips if the chart is larger
than a user's monitor?  I have an application including an interactive chart
that imports jpg images based on a user clicking on a chart symbol.  By
default, I place the image in the upper left of the chart.  If the user has
scrolled towards the bottom of the chart and clicked a symbol, if their
monitor is too small, they then have to scroll back up to view it.  I'd like
to programatically check the visible chart portion upon the click event and
place the image on the chart still within the viewable area.
RLang - 20 May 2008 16:46 GMT
Nevermind, found activewindow.visiblerange functions.

> Hi,
>    Is there a way to programmatically determine the starting or ending
[quoted text clipped - 6 lines]
> to programatically check the visible chart portion upon the click event and
> place the image on the chart still within the viewable area.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.