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