ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can I keep a tab in place? (https://www.excelbanter.com/excel-discussion-misc-queries/260027-how-can-i-keep-tab-place.html)

missy8892

how can I keep a tab in place?
 
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.


Luke M[_4_]

how can I keep a tab in place?
 
Tools - Protection - Protect workbook (for structure)
Or, create a custom button/macro that navigates to the summary sheet.

--
Best Regards,

Luke M
"missy8892" wrote in message
...
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.





All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com