| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
