+ Reply to Thread
Results 1 to 8 of 8

Freezing Worksheet Tabs: Possible with VBA?

  1. 03-25-2018, 12:51 PM #1
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Freezing Worksheet Tabs: Possible with VBA?

    Hi,

    I have an Excel document that has over 100 tabs at the bottom. There are two tabs that I need to have quick access to and the others would be changed less frequently.

    Is there a way I can freeze the first two tabs as you can when you freeze panes?

    It's not a major issue in all honesty but would make life easier!

    Many thanks in advance.

    Steve
    Last edited by AliGW; 03-25-2018 at 01:13 PM.
    Reply With QuoteRegister To Reply
  2. 03-25-2018, 12:53 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,266

    Re: Freezing Tabs

    What do you mean by 'freeze'? If you mean keep the first two tabs visible whilst you scroll across to see others, then no, it's not possible natively. I do not know if it can be done with VBA.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 03-25-2018, 01:11 PM #3
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Freezing Tabs

    Hi AliGW,

    Yes that's what I am after.

    It's a shame. it would make things a little easier.

    Thanks for your help.

    Does anyone know if it is possible with VBA?
    Reply With QuoteRegister To Reply
  4. 03-25-2018, 01:12 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,266

    Re: Freezing Tabs

    I can move the thread for you and we shall see.
    Reply With QuoteRegister To Reply
  5. 03-25-2018, 01:19 PM #5
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Freezing Worksheet Tabs: Possible with VBA?

    Sorry, I didn't realise it would go in another section.

    If you could that would be really helpful! THANK YOU!
    Reply With QuoteRegister To Reply
  6. 03-25-2018, 01:19 PM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,266

    Re: Freezing Worksheet Tabs: Possible with VBA?

    Done and title amended to attract the VBA experts' attention.
    Reply With QuoteRegister To Reply
  7. 03-25-2018, 01:36 PM #7
    kjg
    kjg is offline
    Forum Contributor
    Join Date
    11-30-2005
    Location
    Penzance Cornwall, UK
    MS-Off Ver
    Office 365
    Posts
    198

    Re: Freezing Worksheet Tabs: Possible with VBA?

    Could you not just have a macro to take you to the required sheet?

    I have just recorded the macro below, if I press "Ctrl+Shift+A" it takes me to the sheet named "343" which happens to be my first sheet.

    Please Login or Register  to view this content.
    I hope this is of some use.
    Reply With QuoteRegister To Reply
  8. 03-25-2018, 03:11 PM #8
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Freezing Worksheet Tabs: Possible with VBA?

    Hi kjg

    I will use this. Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Freezing A Row Without Freezing Rows Above Said Row
    By STUARTXL in forum Excel General
    Replies: 2
    Last Post: 02-19-2017, 06:49 AM
  2. [SOLVED] Freezing Tabs
    By billgyrotech in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-08-2015, 01:37 PM
  3. Macro help: Separating data into tabs and creating a table of content of those tabs
    By AntiPivotTable in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2015, 11:57 AM
  4. [SOLVED] Identical data needed on all tabs, want to add a line across all tabs when added in tab1
    By seash in forum Excel General
    Replies: 45
    Last Post: 03-12-2015, 12:46 PM
  5. [SOLVED] Userform with Multi-Tabs and Textboxes losing values when switching tabs
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-23-2014, 11:35 AM
  6. Macro to select multiple worksheet tabs based on color of the tabs
    By drewbizz in forum Excel General
    Replies: 6
    Last Post: 02-01-2012, 05:29 PM
  7. [SOLVED] Freezing worksheet tabs
    By Colin Foster in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 07:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1