Related:
- Disable right click on sheet tabs in excel (MAC) using VBA code
- Google sheet right to left - Guide
- Battery reset code - Guide
- Mark sheet in excel - Guide
- Number to words in excel formula without vba - Guide
- Psiphon for mac - Download - VPN
3 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Oct 14, 2015 at 07:06 AM
Oct 14, 2015 at 07:06 AM
Hello Maya,
You could try the Workbook_Open event:-
Right click on your main tab, select "view code", in the Project Explorer side bar select "This WorkBook" and in the big white field, paste the above code.
It may work.
Cheerio,
vcoolio.
You could try the Workbook_Open event:-
Private Sub Workbook_Open()
Application.CommandBars("Ply").Enabled = False 'Hides SheetTab Menu
End Sub
Right click on your main tab, select "view code", in the Project Explorer side bar select "This WorkBook" and in the big white field, paste the above code.
It may work.
Cheerio,
vcoolio.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 12, 2015 at 03:26 PM
Oct 12, 2015 at 03:26 PM
one way would to use events
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub
