Forum Discussion

Vbellamy's avatar
Vbellamy
Copper Contributor
Jan 16, 2023

Freezing tabs

How can I have a Specific tab always be 1st on the bottom of worksheet 

excel
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jan 16, 2023

    Vbellamy 

    You can do it with VBA and write a macro that automatically calls the desired spreadsheet when the file is opened.

    Open the corresponding workbook and there the VisualBasic Editor (Alt+F11).

    In Project Explorer, click ThisWorkbook to display the code window.

    In the code window, select "Workbook" from the list on the left.

    Paste this code into the right list.

     

     

    Private Sub Workbook_Open ()

Sheet(2).Activate 'You can insert worksheet number in the brackets.

end sub

     

     

     

    Hope I was able to help you with this info.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources