View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Excel worksheet tabs

As long as the Excel window has been maximised the only reason you won't be able
to see the tabs should be that someone has used the option og Tools / Options /
View Tab / and unchecked 'Sheet tabs'. If putting this back is not an option
then you might also just try CTRL+PAGEUP or CTRL+PAGEDOWN which will tab through
the sheets. If all that isn't enough then I can't believe you will be able to
run any script, but if by any chance you can then try the following link:-

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Bill Hall" wrote in message
...
Is it possible to move the worksheet tabs in a workbook so that are visible
on the left or right hand side of the screen instead of being at the bottom?

The school computer security does not allow the use of right-clicking on a
mouse button, and with the worksheet tabs hidden from view by the taskbar -
which I can't hide, (please don't ask me why, but my programming has hidden
all possible non-used stuff from kids' roving fingers!), the students are not
able to navigate from one worksheet to another.

If not, can anyone please suggest the code for double clicking on a button
that opens another worksheet automatically.

I can then set up an intro page to my workbook where navigation to all
worksheets is possible.

thanks Bill



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004