Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
disable right click on mouse
is it possible to disable the right click (copy/cut/paste) on a mouse in
excel spreadsheet. jatman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
disable right click on mouse
In the Immediate Window of the VBE
Application.CommandBars("Cell").Enabled = False 'True to reset You may want it disabled for one worksheet but not another or one workbook and not others. Post back with more details if you want something tailored. Gord Dibben MS Excel MVP On Wed, 4 Jun 2008 15:55:03 -0700, jatman wrote: is it possible to disable the right click (copy/cut/paste) on a mouse in excel spreadsheet. jatman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
disable right click on mouse
Application.Commandbars("Cell").Enabled = False
disables the menu completely. Be sure to enable it or the user will be stuck with it this way. Another option is just to disable it on a specific sheet: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub This must be pasted into the sheet's module (right click sheet tab and click View Code. Or for an entire workbook: Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub Pasted into the ThisWorkbook module. -- Jim "jatman" wrote in message ... is it possible to disable the right click (copy/cut/paste) on a mouse in excel spreadsheet. jatman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
right mouse click not working | Excel Discussion (Misc queries) | |||
Disable right mouse click when in Full screen mode | Excel Discussion (Misc queries) | |||
right mouse click in excel | Excel Discussion (Misc queries) | |||
disable right mouse click on a scatter graph? | Charts and Charting in Excel | |||
Each Click of the Mouse | Excel Discussion (Misc queries) |