Forum Discussion

Gerald Farro's avatar
Gerald Farro
Copper Contributor
Jun 08, 2018

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 Kim's avatar
    Lorenzo Kim
    Bronze 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?

Resources