Worksheet Tabs
 

Hi,

Is it possible to disable the pop-up that appear when sheet tabs are
right-clicked.

All sheets are protected (userinterfaceonly)

If yes, how ?

regards,
Don

--

Worksheet Tabs
 

Donald,

Use the following code

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Donald Lloyd" wrote in message
...
Hi,

Is it possible to disable the pop-up that appear when sheet tabs
are
right-clicked.

All sheets are protected (userinterfaceonly)

If yes, how ?

regards,
Don

--

Worksheet Tabs
 

Thank you Chip, I'll give it a go.

It seems a very cryptic solution, I must say. Is it documented ?

regards,
Don

--

"Chip Pearson" wrote in message
...
Donald,

Use the following code

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Worksheet Tabs
 

Hi Don,
It's always a good idea to search for your answers on web pages, or
in Excel newsgroups before posting. If you consider the Microsoft
MS KB, and support sites documentation then a search on the
Google toolbar (note period between right click)
disable right.click worksheet.tab*

While the use of period is not documented it appears to pick up
words like "right click" right-click rightclick as some other search
engines do. It is not yet documented on Google though.

turns up (link is the way Google shows it, first of 71 hits)
XL97: How to Disable Shortcut Menus
http://support.microsoft.com/support/ kb/articles/Q161/4/40.asp


A search of newsgroup postings would also turn up lots of hits
http://groups.google.com/advanced_gr...Excel*&num=100

Don't worry too much about being too restrictive, there are generally
so many hits that you'll still get something -- even if you misspell a
word, others may have misspelled it as well. But it is best to
be very careful with spelling and in the case of error messages
to key them in *exactly* as presented.

More information on searching newsgroups
http://www.mvps.org/dmcritchie/excel/xlnews.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote
It is documented, but not as a specific 'How to disable the Sheet tab
right-click option'. Rather, all menus and toolbars are Commandbars, they
have an Enabled property that does just that, and the sheet right click
Commandbar is called 'Ply'. So all Chip did was to put those bits of
information together to give you an answer.

"Donald Lloyd" wrote in message...
Thank you Chip, I'll give it a go.

It seems a very cryptic solution, I must say. Is it documented ?

"Chip Pearson" wrote in message
...
Donald,

Use the following code

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

Worksheet Tabs
 

I tried this code successfully, but since then << even though I re-boot my
computer
I can no longer <<even on a new book right-click on a sheet tab and get
the short-cut menu to come up; what gives? How can I get the capability
back?


"Chip Pearson" wrote in message
...
Donald,

Use the following code

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Donald Lloyd" wrote in message
...
Hi,

Is it possible to disable the pop-up that appear when sheet tabs
are
right-clicked.

All sheets are protected (userinterfaceonly)

If yes, how ?

regards,
Don

--

Worksheet Tabs
 

Never Mind - I went back to the file where I had the code and changed it to
TRUE
That solved the problem - obviously this procedure "Continues in
effect"........................................... ..........................
...............................
....................
...................
.................
Tks,

"JMay" wrote in message news:L6kXa.5492$qf.3837@lakeread06...
I tried this code successfully, but since then << even though I re-boot my
computer
I can no longer <<even on a new book right-click on a sheet tab and get
the short-cut menu to come up; what gives? How can I get the capability
back?


"Chip Pearson" wrote in message
...
Donald,

Use the following code

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Donald Lloyd" wrote in message
...
Hi,

Is it possible to disable the pop-up that appear when sheet tabs
are
right-clicked.

All sheets are protected (userinterfaceonly)

If yes, how ?

regards,
Don

--