+ Reply to Thread
Results 1 to 3 of 3

Scroll on a chartsheet excel vba

  1. #1
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Scroll on a chartsheet excel vba

    Hello everyone,

    I want to scroll using VBA such that the upper left corner of the chartsheet (Not normal worksheet) is exactly at the upper left point of the active window. Is there any way I can accomplish this?

    I appreciate any help on this.

    Regards
    Sourabh
    excel1.png
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Scroll on a chartsheet excel vba

    http://www.techrepublic.com/blog/10-...g-excel-chart/

  3. #3
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Scroll on a chartsheet excel vba

    Thank you so much for the reply

    This is not something I am looking for. I want to scroll the chartsheet "window" not the chart. I want the chartsheet window's left top corner to perfectly align with the left top corner of the excel window. You can see in the image attached above (highlighted by red arrow). I want to move the whole chartsheet window to align with excel's window.

    Simply, just like we scroll in the normal sheet. I need a code to be able to scroll in chartsheet window. ActiveWindow.ScrollColumn and ActiveWindow.ScrollRow doesnt work for a chartsheet.

    Any ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-17-2016, 04:45 PM
  2. [SOLVED] Select a chart from a chartsheet in VBA
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2015, 11:38 PM
  3. [SOLVED] Delete Chartsheet
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-11-2014, 06:27 PM
  4. Excel 2013 : Slicers don't scroll when i scroll the sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2014, 10:23 AM
  5. Replies: 4
    Last Post: 04-15-2014, 02:22 AM
  6. RangeFromPoint ... on a chartsheet ?
    By MrT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2006, 09:35 AM
  7. [SOLVED] 1 ChartSheet, 10 worksheets
    By Martin Wheeler in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-22-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1