View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default 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.