How to Disable the Insert Worksheet tab at bottom of screen

[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]

hi Steve,

Application.CommandBars("Ply").Enabled = False

 

[GS]

isabelle pretended :

hi Steve,

Application.CommandBars("Ply").Enabled = False

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

 

[SS]

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

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

 

[SS]

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

Another off the wall question....

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

Thanks!!
Steve

 

[GS]

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

Check out the 'ForeColor' property

 

[Jan T]

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

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
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.