KeepTrying
Active Member
- Joined
- Aug 19, 2012
- Messages
- 276
- Office Version
- 365
- 2010
- Platform
- Windows
Dear Guys,
I have an older macro which ran well in earlier versions: when I right clicked on a cell and selected "Insert Comment": a macro ran automatically: of course I added following code to the appropriate sheet
As we know, right lick menu has changed from 2018 autumn in O365. So when I right click on a cell I need to select "New Note" (not "New Comment"!) instead of "Insert comment":
My problem, that code above doesn't work if I right click and choose "New Note" (I use O365 now) despite it worked in older versions (like in 2010).
Can anyone help?
Thank you.
I have an older macro which ran well in earlier versions: when I right clicked on a cell and selected "Insert Comment": a macro ran automatically: of course I added following code to the appropriate sheet
VBA Code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Application.CommandBars("Cell").Controls("Insert Comment").OnAction = "MacroName_ToBeRun"
End Sub
As we know, right lick menu has changed from 2018 autumn in O365. So when I right click on a cell I need to select "New Note" (not "New Comment"!) instead of "Insert comment":
My problem, that code above doesn't work if I right click and choose "New Note" (I use O365 now) despite it worked in older versions (like in 2010).
Can anyone help?
Thank you.