Forum Discussion
Gerald Farro
Jun 08, 2018Copper Contributor
renaming or deleting a sheet
right click is not letting me rename or delete a sheet in a workbook. Using a MacBook Pro. it does let me sometime.
- Lorenzo KimBronze Contributor
Mr Farro
If I read you right, you want to be able to use "right click" on tab, Mr Jamil Mohammad before taught me how to do it (although the reverse). Press ALT F11 then copy paste below to ThisWorkbook.
I hope this will help you.
Private Sub Workbook_Open()
Application.CommandBars("ply").Enabled = True
End Sub Gerald, you don't see right click menu at all, or Rename and Delete are greyed in it? And are you sure your workbook is not protected?