+ Reply to Thread
Results 1 to 3 of 3

Freezing multiple tabs

  1. #1
    Registered User
    Join Date
    04-24-2020
    Location
    Belgium
    MS-Off Ver
    Office 365
    Posts
    2

    Question Freezing multiple tabs

    Hi there,

    It seems my macro to freeze the first tab in place while scrolling through everything else is working perfectly (I'm working on a sheet with 150+ tabs)
    Although I can't seem to get the second tab to freeze in place with the first one

    The current formula to freeze the first one (which is working just fine):

    Please Login or Register  to view this content.

    My attempt to get the second one to freeze aswell:

    Please Login or Register  to view this content.
    The latter does not work at all
    Any help if possible would be appreciated

    Jeroen
    Last edited by Jeroen_JTBC; 04-24-2020 at 10:36 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Freezing multiple tabs

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  3. #3
    Registered User
    Join Date
    04-24-2020
    Location
    Belgium
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Freezing multiple tabs

    Thank you,

    I've changed the post to the style you requested

+ 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. Calculating Sumifs Across Multiple Tabs; allowing Tabs to change or be added/deleted
    By Charles A. Othon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2019, 04:49 PM
  2. Freezing Worksheet Tabs: Possible with VBA?
    By splottoman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2018, 03:11 PM
  3. Freezing Worksheet Tabs: Possible with VBA?
    By splottoman in forum Excel General
    Replies: 3
    Last Post: 03-25-2018, 01:12 PM
  4. [SOLVED] Freezing Tabs
    By billgyrotech in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-08-2015, 01:37 PM
  5. [SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-06-2015, 07:42 AM
  6. Replies: 6
    Last Post: 02-01-2012, 05:29 PM
  7. Freezing worksheet tabs
    By Colin Foster in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 07:40 PM

Tags for this Thread

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