Event proceedures

[ksnapp]

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

 

[Guest]

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

 

[Bob Phillips]

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)

Did you Save and Close the workbook after the code was pasted. These

events are not activated until after you do!