Worksheet Tabs

  • Thread starter Thread starter Donald Lloyd
  • Start date Start date
D

Donald Lloyd

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

--
 
Donald,

Use the following code

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Thank you Chip, I'll give it a go.

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

regards,
Don
 
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_group_search?q=group:*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
 
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 said:
Donald,

Use the following code

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
Click to expand...
 
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 said:
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?
Click to expand...
 
Back
Top