I just changed computer and my .xlsm file (which is strored on google drive) doesn't behave correctly on right clicks.
If the selected cell is A1 for example. If I then right click on C3, instead of executing the code thats within "Worksheet_BeforeRightClick" it doesn't execute the code immediatly.
The first thing it does is deploy the dropdown menu below C3 and select C3. If I then right click again, it execute the code.
So I have to right click twice and I have an undesired dropdow menu on the first click.
Example
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
MsgBox "Hi"
Cancel = True
End Sub
fs I rightclick any cell on the sheet that contains this code, it will first show me the drop down menu (the one that should not apear thanks to Cancel=true) and select the cell.
I have to right click a second time for "Hi" to pop in the message box and the dropdown menu won't appear which is the desired effect.
Does anyone knows the solution to this problem?
If the selected cell is A1 for example. If I then right click on C3, instead of executing the code thats within "Worksheet_BeforeRightClick" it doesn't execute the code immediatly.
The first thing it does is deploy the dropdown menu below C3 and select C3. If I then right click again, it execute the code.
So I have to right click twice and I have an undesired dropdow menu on the first click.
Example
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
MsgBox "Hi"
Cancel = True
End Sub
fs I rightclick any cell on the sheet that contains this code, it will first show me the drop down menu (the one that should not apear thanks to Cancel=true) and select the cell.
I have to right click a second time for "Hi" to pop in the message box and the dropdown menu won't appear which is the desired effect.
Does anyone knows the solution to this problem?
