Results 1 to 2 of 2

macro w/ Freeze panes keeps shifting where panes freeze on worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2014
    Location
    Minneapolis
    MS-Off Ver
    MS Office 2010 Pro 32 bit
    Posts
    23

    macro w/ Freeze panes keeps shifting where panes freeze on worksheet

    I have multiple Form Control buttons used to navigate to other locations on a ws which would otherwise require a lot of scrolling and/or paging up/down.

    At the top section I have several buttons labeled Go To and then in the target areas I have buttons labeled Go Home to return to range "A1".

    Here's the code from one of the buttons:

    Sub GoTo_IncomeStmtConsol()
        Application.ScreenUpdating = True
        Application.Goto Reference:="Income_Stmt_Consol"
        ActiveWindow.SmallScroll Down:=30
        ActiveWindow.FreezePanes = True
    End Sub
    What I don't understand is sometimes this works just fine. The macro runs, goes to the designated named range, which in this case is "Income_Stmt_Consol" which also happens to be cell C91 ... and the panes freeze around the range with both vertical and horizontal panes as you'd expect w/ C91 in the top left corner. However, at the moment it's just locking panes horizontally at row 109.

    Puzzling.

    Any one have an explanation or solution to this problem?? BTW ... it does seem to be intermittent.

    Thanks!!

    Steve

    Cross posted: If a solution is arrived at I will update all posts accordingly.


    HTML Code: 
    HTML Code: 
    HTML Code: 
    Last edited by sschwant; 01-10-2015 at 11:04 AM. Reason: cross posted

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Freeze Panes - Can I freeze a specific set of cells?
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 09:17 AM
  2. Excel 2003 freeze panes won't freeze top row only
    By macbone2002 in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 11:10 AM
  3. Freeze Panes-When freeze panes is employed it leave a black line
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 01:40 AM
  4. Replies: 1
    Last Post: 01-25-2006, 11:36 AM
  5. freeze the worksheet panes
    By tagi1977 in forum Excel General
    Replies: 1
    Last Post: 11-14-2005, 09:10 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