Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
can u disable the right click button in excel
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
Hi,
Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste this code in on the right Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Steve davis" wrote: can u disable the right click button in excel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
high work well thanks
can it be done on the main menu bar were file to help is as well |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
Hi,
Yes it can, have a look here http://www.rondebruin.nl/menuid.htm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Steve davis" wrote: high work well thanks can it be done on the main menu bar were file to help is as well |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
high was hoping could ajust code to do all the things i wont but cant
looked at http://www.rondebruin.nl/menuid.htm will keep in fav for futher use but what i need is to stop the extra standard to customize menu poping up when u right click in the light blue area on the Command bar menu |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
finaly found thank
Application.CommandBars("Toolbar List").Enabled = False |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click
Tip 4 from the page
Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above. On Error Resume Next Application.CommandBars("Toolbar List").Enabled = False On Error GoTo 0 This prevents users double-clicking on the Toolbar area to open the (Customize Toolbars) dialog in Excel 2002 and above. Application.CommandBars.DisableCustomize = True If you want to remove Type a question for Help on the Worksheet Menu Bar you can use this in Excel 2002 and above. True = hidden and False = visible Application.CommandBars.DisableAskAQuestionDropdow n = True You can use this to avoid the error in Excel 2000 If Val(Application.Version) 9 Then CallByName CommandBars, "DisableCustomize", VbLet, True CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve davis" wrote in message ... finaly found thank Application.CommandBars("Toolbar List").Enabled = False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a click on + symbol to open a root and click on -. | Excel Discussion (Misc queries) | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel |