Related:
- Disable right click on sheet tabs in excel (MAC) using VBA code
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Google sheet right to left - Guide
- How to screenshot excel sheet - Guide
- Vba code to search data in excel - Guide
3 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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
4479
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
