hide sheet tab and protect

  • Thread starter Thread starter x taol
  • Start date Start date
X

x taol

tools->option->sheet tab....... uncheck and keep up the setting...

i want to hide sheet tab and keep the setting..
anyone does not change the setting.
is it possible?
 
Looking at that page in the Option, you see it under "Window options" and if
you record a macro whilst changing that setting, you get something like

ActiveWindow.DisplayWorkbookTabs = False

So it is setting of the windows of a workbook, not an application wide
setting.
You could set it False in the WB open event though.

NickHK
 

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

Excel Move or Copy Stopped Working? 0
password protect individual sheets 1
Hiding the Insert New Worksheet tab in Excel 2007 3
Control of Sheet Tab functions? 2
hide multiple worksheets based on a formula value in one cell 1
Syntax to match sheet by codename 4
hide sheet? uncheck sheet tabs? or ??? 1
tabs in webpage 1

Back
Top