-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
right click
- Thread starter TODDY
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Right click the sheet tab and choose View Code. Look for a procedure that begins:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Upvote
0
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Hi
You probably have some code written into the ThisWorkbook module so you'll probably want to check that via the VBE (Alt+F11) and navigate to your workbook name in the Projects pane (top left) and double-click on the ThisWorkbook module.
You're looking for a sub that begins:
Depending on what's been coded, you may be able to simply delete this sub, save the workbook down and reopen.
Hope this helps!
Richard
You probably have some code written into the ThisWorkbook module so you'll probably want to check that via the VBE (Alt+F11) and navigate to your workbook name in the Projects pane (top left) and double-click on the ThisWorkbook module.
You're looking for a sub that begins:
Code:
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)Depending on what's been coded, you may be able to simply delete this sub, save the workbook down and reopen.
Hope this helps!
Richard
Upvote
0
