How to Disable the Insert Worksheet tab at bottom of screen

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

Folks,
Although very helpful when you need it, it can be a big neusance.
Is there a way to disable or remove from the current worksheet in
2010?

Thanks!
-Steve
 
isabelle pretended :
hi Steve,

Application.CommandBars("Ply").Enabled = False
Click to expand...

Isabelle,
I believe Steve is referring to the InsertSheet icon on the right side
of tab strip, NOT the popup menu.
 
isabelle pretended :



Isabelle,
I believe Steve is referring to the InsertSheet icon on the right side
of tab strip, NOT the popup menu.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...

That is correct about the icon, not the menu option; but that is
interesting...

I was able to find that protecting the entire workbook will also
disable that 'thing'. I have never gone to that extreme with my
files, but i have tried it now, and seems to be working ok.
Is there any pitfalls to protecting the entire workbook like that?
Otherwise, i could use your code to go on file open, or something
similar.

Thanks for the help! Much appreciated!
-Steve
 
isabelle pretended :



Isabelle,
I believe Steve is referring to the InsertSheet icon on the right side
of tab strip, NOT the popup menu.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...

Another off the wall question....

What are the possiblilities of changing the checkmark in a checkbox to
green instead of boring black :-)

Thanks!!
Steve
 
SS pretended :
Another off the wall question....

What are the possiblilities of changing the checkmark in a checkbox to
green instead of boring black :-)

Thanks!!
Steve
Click to expand...

Check out the 'ForeColor' property
 
Folks,
Although very helpful when you need it, it can be a big neusance.
Is there a way to disable or remove from the current worksheet in
2010?

Thanks!
-Steve
Click to expand...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
Hi, Steve.

I don't think it is possible to disable the worksheet Tabs and having
them visible at the same time without protecting the whole workbook.

However, if you mean Hiding the worksheet tabs at the bottom of the
worksheets, you can use this method:

Sub HideWBtabs()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

To get them visible again, change the word False with True and run the
code again..

Or manually ...

Go to the File Tab to the very Left on the Ribbon, go to Advanced and
uncheck Show WorksheetTabs.

Hope that gave you some extra ideas...

Regards



Jan T.
 
Back
Top