how can I keep a tab in place?

M

missy8892

I have workbooks with multiple worksheets. I would like to keep the summary
tab in a fixed (first) position so that the user can easily, quickly find it
without using the l<, <, >, >l (arrow) tabs.
I use hyperlinks to get from the summary tab to the other tabs, and I know I
can hyperlink tab back... but I'd rather not use the hyperlinks too much.
 
L

Luke M

Tools - Protection - Protect workbook (for structure)
Or, create a custom button/macro that navigates to the summary sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to refer to tab names? 1
how do i link the names of tabs in a workbook to a summary page? 1
Referencing a tab in a formula 2
Using text from cell in a range lookup 1
Cacatenation and SUMPRODUCT 4
How do I activate the "greyed out" hyperlink function 2
Quickly locate a specific page/tab in workbook 4
How do I email a single spreadsheet tab in excel? 2

Top