|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 3rd, 2010, 12:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
right click
can u disable the right click button in excel
|
|
#2
April 3rd, 2010, 01:11 PM
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
April 3rd, 2010, 01:25 PM
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
April 3rd, 2010, 01:36 PM
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
April 3rd, 2010, 02:05 PM
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
April 3rd, 2010, 02:59 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
right click
finaly found thank
Application.CommandBars("Toolbar List").Enabled = False
|
|
#7
April 4th, 2010, 01:30 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
