I have disabled various User functions within a specified Workbook, depending on the User.
A couple of examples are:
'Prevent Right-Click on WorkSheet Tab
Application.CommandBars("PLY").Enabled = False
'Prevent Right-Click on WorkSheet Cells
Application.CommandBars("CELL").Enabled = False
The problem is that one user claims that he is now unable to 'Right Click' on Cells in OTHER Excel workbooks.
Does anyone know how to resolve this? i.e. To limit the restrictions to the specific Workbook?
Thanks in advance,
A Northern Soul