Forum Discussion
Freezing tabs
How can I have a Specific tab always be 1st on the bottom of worksheet
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.
I know I don't know anything (Socrates)