Worksheet Tab Freeze

K

KyleG

Well-known Member
Joined
Jun 12, 2004
Messages
623
Is it possible to keep the first Worksheet tab visible even when scrolling across a number of worksheets. This way a user can get back to the main page without having to scroll back across.

Thanks

Kyle
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sort by date Sort by votes
No that is not possible. The user can right click on those navigation arrows to the left of the sheet tabs, and left click on the sheet name they want to be taken to, or they can left click on that left-most arrow which will take them to the first index sheet.
 
Upvote 0
Thanks for that worth a shot. Didnt know about the left most button hadnt ever thought to use it. Lol.

Thanks

Kyle
 
Upvote 0
Alternitively, you can record a simple macro to go to sheet 1, and put a button for it on every sheet.
 
Upvote 0
Just to clarify, I wrote "or they can left click on that left-most arrow which will take them to the first index sheet" which is technically not correct. Clicking that leftmost arrow button will make the first index tab visible. Once it is visible you can select it if it isn't activated already, so really it's a potentially at-most negotiation of two mouse clicks.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
How to make chart pan with data
Replies
2
Views
105
Guzzlr
G
G
  • Solved
Excel File with 50+ Tabs
Replies
2
Views
354
Fluff
Fluff
W
  • Question
Clearing ghost images
Replies
1
Views
88
WhoCanDo
W
H
  • Question
How to hide some columns while allowing users to 'Format Columns'
Replies
2
Views
334
hcgood
H
F
  • Question
Filtering/Copying a table via VBA.
Replies
2
Views
168
frobeniusabnorm
F

Forum statistics

Threads
1,215,830
Messages
6,127,133
Members
449,361
Latest member
VBquery757

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top