| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 -- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 -- |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
| Worksheet Tabs | Excel Worksheet Functions | |||
| Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
| worksheet tabs | Excel Discussion (Misc queries) | |||
| Worksheet Tabs | Excel Discussion (Misc queries) | |||
Hybrid Mode
