Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable sheets tabs right mouse button!
I have a workbook, I have to protect the workbook from copy past
cut.... this is already done and working. My problem: 1) How is it possible to disable the right mouse menu appearing whe you are over the sheet tabs and you right click the mouse? If i don't do yhis my previous work is useless! And despite cut copy and paste are disable, the option copy & copy an move is still enable from the sheet tabs right mouse buton! Many thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable sheets tabs right mouse button!
Hi
put the following code in your worksheet module: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub -- Regards Frank Kabel Frankfurt, Germany I have a workbook, I have to protect the workbook from copy paste cut.... this is already done and working. My problem: 1) How is it possible to disable the right mouse menu appearing when you are over the sheet tabs and you right click the mouse? If i don't do yhis my previous work is useless! And despite cut copy and paste are disable, the option copy & copy and move is still enable from the sheet tabs right mouse buton! Many thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable sheets tabs right mouse button!
application.CommandBars("ply").enabled=false
-- HTH ------- Bob Phillips "Andoni " wrote in message ... I have a workbook, I have to protect the workbook from copy paste cut.... this is already done and working. My problem: 1) How is it possible to disable the right mouse menu appearing when you are over the sheet tabs and you right click the mouse? If i don't do yhis my previous work is useless! And despite cut copy and paste are disable, the option copy & copy and move is still enable from the sheet tabs right mouse buton! Many thanks --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable sheets tabs right mouse button!
Try
in your ThisWorkbook Code Module: - - - - - - - - - - - - - - - - - - - - - - - - - - Private Sub Workbook_Open() Application.CommandBars("PLY").Enabled = False End Sub Private Sub Workbook_Activate() Application.CommandBars("PLY").Enabled = False End Sub Private Sub Workbook_Deactivate() Application.CommandBars("PLY").Enabled = True End Sub - - - - - - - - - - - - - - - - - - - - - - - - - - -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disable right click on mouse | Excel Discussion (Misc queries) | |||
disable right mouse click on a scatter graph? | Charts and Charting in Excel | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) | |||
Disable the right mouse button?? | Excel Programming | |||
disable keyboard/mouse from vba for all programs? | Excel Programming |