Sheet Names Disappeared

bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by Terry

The sheet names disappeared....I went to Excel Options and they are turned on
for the WB and Sheets still they don't appear
HELP

Use this simple vba code

Private Sub Workbook_Open()
ActiveWindow.DisplayWorkbookTabs = True
End Sub

all the best

__________________
Thanks
Bala

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
sheet tabs disappeared	pegman	Excel Discussion (Misc queries)	2	September 12th 08 04:53 AM
My sheet tabs disappeared. Options shows they are active.	Cairos	Excel Discussion (Misc queries)	5	March 18th 08 07:35 AM
Sheet tabs & horizontal scrollbar disappeared - Excel 2003	RHK	Excel Discussion (Misc queries)	3	November 29th 07 11:08 PM
The sheet tabs at the bottom of my worksheet has disappeared?	tresses8m	New Users to Excel	4	June 5th 07 11:04 PM
My sheet tabs disappeared with entered data. Can it be restored?	Irene V in NJ	Excel Discussion (Misc queries)	8	September 12th 06 05:43 PM

All times are GMT +1. The time now is 10:39 AM.

About Us