+ Reply to Thread
Results 1 to 3 of 3

VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013

  1. #1
    Registered User
    Join Date
    06-10-2015
    Location
    Minneapolis, MN
    MS-Off Ver
    2013
    Posts
    1

    VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013

    We have a batch job that programmatically generates an SSRS report in Excel format and then applies a VBA Excel macro which is contained in another Excel worksheet. This procedure had been working fine when used with Excel 2010. When we upgraded our servers where the batch job is run to Excel 2013, the behavior of the formatting changed.

    Specifically, one of the issues is with the freezing of panes. In the VBA macro a cell is selected on a sheet and the “ActiveWindow.FreezePanes = True” is called to freeze the panes. This was working when navigating the finished worksheet when we had Excel 2010 installed but is not after upgrading to Excel 2013. Curiously, when the finished worksheet is opened in Excel and you select “View -> Freeze Panes” the “Unfreeze Panes” option is available - not the “Freeze Panes” option. It’s as if Excel knows the panes have been frozen in this worksheet but is not honoring it when navigating the worksheet.

    Another twist to this is that the formatting does work correctly if the batch job is run under certain Windows user accounts.

    Perplexed here. Any ideas??

    Thanks!

    John R.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013

    Upgrades from 2010 to 2013 hardly ever cause working VBA to fail just because of the upgrade. It is likely that something else has changed too. This is next to impossible to diagnose without seeing the file, or at least all of the code.

    Quote Originally Posted by jayar2112 View Post
    In the VBA macro a cell is selected on a sheet and the “ActiveWindow.FreezePanes = True” is called to freeze the panes.
    Which cell? If something changed in which cell was selected then the freeze might not behave the way you expect. For example, if a cell in the first row is selected, but you scroll down, you won't notice the freeze; you'll only see it if you scroll to the right.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013

    Upgrades from 2010 to 2013 hardly ever cause working VBA to fail just because of the upgrade. It is likely that something else has changed too. This is next to impossible to diagnose without seeing the file, or at least all of the code.

    Quote Originally Posted by jayar2112 View Post
    In the VBA macro a cell is selected on a sheet and the “ActiveWindow.FreezePanes = True” is called to freeze the panes.
    Which cell? If something changed in which cell was selected then the freeze might not behave the way you expect. For example, if a cell in the first row is selected, but you scroll down, you won't notice the freeze; you'll only see it if you scroll to the right.

+ 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. VBA working in Excel 2013 but not 2010
    By sb2323 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2015, 07:26 AM
  2. Macro code working fine in excel 2013 but not in excel 2010.
    By sere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2014, 02:23 AM
  3. Spreadsheet macros working in Excel 2010 but not in Excel 2013
    By boatbabe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 12:03 PM
  4. Macro from 2010 not working correctly in 2013
    By Phixer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:24 PM
  5. [SOLVED] Excel 2010 to Excel 2013 Eroor? PivotTable, ListBox VBA not working.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 07:49 AM

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