Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Different options to hide tabs in Excel

Hey all, I know of two ways to hide the tabs of worksheets in Excel (I'm
using 2003).

1. By going into "Tools"-"Options" and then unclicking "Sheet Tabs"
2. By going into the Sheets (whose tab you want to hide) and selecting
"Format"-"Sheet"-"Hide"

However, I've been looking at this one excel file and I can't figure out how
it is hiding its tabs.

It doesn't seem to be hiding the tabs with either of the above two methods
since:
1. The "Sheet Tabs" checkbox is clicked (i.e. they should be showing
according to that). Also, I've tried deselecting that checkbox, clicking
"ok" and then tried going back in and selecting it and clicking "ok" and
still the tabs don't appear.
2. I can't unhide the sheets under "Format"-"Sheet"-"Unhide". Also in the
VB code that shows the sheets, it just uses the "Select" method of the sheets
- which wouldn't be possible if the sheet was not visible (i.e. you would
have to make the sheet visible first).

I think this excel file may have been created with an earlier version of
excel and therefore it may be using an alternate means to hide the tabs.

I should add, that no tabs control is even visible in the excel workbook -
i.e. regardless of what sheet you are on - you can't access the tab control
on the bottom of the page. Which matches the criteria of the "Sheet Tabs"
checkbox - but it is definitely checked.

Thanks for any suggestions as to how these tabs (specifically the whole tab
control) is being hidden.

Novice
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
tabs are missing even though 'tools-options-view-sheet tabs' ok? rgranell Excel Worksheet Functions 3 August 16th 08 04:25 PM
Excel Options not displaying - some tabs only ECD Excel Discussion (Misc queries) 0 March 12th 07 02:27 PM
I have no access to the "tabs" on the options menu of excel Noel W Excel Discussion (Misc queries) 1 July 14th 05 02:24 AM
Different options to hide tabs in Excel Pete McCosh Excel Programming 0 September 21st 04 04:10 PM
Different options to hide tabs in Excel papou[_10_] Excel Programming 1 September 21st 04 04:01 PM


All times are GMT +1. The time now is 03:06 PM.

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

About Us

"It's about Microsoft Excel"