sheet tabs disappear

L

Li Jianyong

I have got a sheet from the internet,when I open it ,I did not found any
sheet tabs. it is very interesting for me to design some sheet in this way.
so people can not click the tab. When I try it by myself,I found I can not
hide all the tabs by righ click the tab ->Hide

How to hide all the tabs?
 
L

Li Jianyong

I don't remember the link. if you want,I can send you by email.

I read the code you provided,it seems to hide all the sheet, not sheet.tab
 
S

Sheeloo

Try Don's suggestion
Excel 2007 navigation;
OFFICE BUTTON -> Excel Options -> Advanced -> Display options for this
workbood -> Show sheet tabs
Clear the check box
 
L

Li Jianyong

thanks . it works as what I want now.

Sheeloo said:
Try Don's suggestion
Excel 2007 navigation;
OFFICE BUTTON -> Excel Options -> Advanced -> Display options for this
workbood -> Show sheet tabs
Clear the check box
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
How to set tabs in work document 0
Found few bugs in my daily routine of work in excel for MAC 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Found few bugs in my daily routine of work in excel for MAC 0
Can I hide sheet tabs so only some are accessible? 3
Problem with sheet tabs 2
Use a master workbook to carry over changes to multiple workbooks 1

Top