View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Soo Cheon Jheong[_2_] Soo Cheon Jheong[_2_] is offline
external usenet poster
 
Posts: 46
Default Disable sheets tabs right mouse button!

Try

in your ThisWorkbook Code Module:

- - - - - - - - - - - - - - - - - - - - - - - - - -
Private Sub Workbook_Open()

Application.CommandBars("PLY").Enabled = False

End Sub

Private Sub Workbook_Activate()

Application.CommandBars("PLY").Enabled = False

End Sub

Private Sub Workbook_Deactivate()

Application.CommandBars("PLY").Enabled = True

End Sub
- - - - - - - - - - - - - - - - - - - - - - - - - -


--
Regards,
Soo Cheon Jheong
_ _
^вп^
--