Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event proceedures
I can't get event procedures to work for me
i pasted this one on the code window for sheet one and it didn't work Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, _ Cancel As Boolean) Cancel = True MsgBox "Shortcut menus are disabled in this worksheet!" End Sub hel -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event proceedures
Did you Save and Close the workbook after the code was pasted. These events are not activated until after you do
----- ksnapp wrote: ---- I can't get event procedures to work for m i pasted this one on the code window for sheet one and it didn't wor Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, Cancel As Boolean Cancel = Tru MsgBox "Shortcut menus are disabled in this worksheet! End Su hel -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event proceedures
Not true, type it in and it works immediately.
OP< are you sure you put the code in the worksheet code module, not a standard code module? To do so, right-click the sheet tab, select View Code from the menu, and paste the code in. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "chris" wrote in message ... Did you Save and Close the workbook after the code was pasted. These events are not activated until after you do! ----- ksnapp wrote: ----- I can't get event procedures to work for me i pasted this one on the code window for sheet one and it didn't work Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, _ Cancel As Boolean) Cancel = True MsgBox "Shortcut menus are disabled in this worksheet!" End Sub help --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
event vba | Excel Worksheet Functions | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
Do Event | Excel Programming | |||
change event/after update event?? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |