Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fun Place Bob Myers Excel Worksheet Functions 1 January 16th 08 12:14 AM
No place for sum [email protected] Excel Worksheet Functions 4 March 28th 07 02:52 AM
Nil in Place Off #N/A Steved Excel Worksheet Functions 2 April 6th 06 02:41 AM
This place ROX!! brodiemac Excel Discussion (Misc queries) 0 December 22nd 05 03:21 PM
1st, 2nd, 3rd Place etc..... JohnT Excel Worksheet Functions 7 January 9th 05 12:41 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"