Excel 2003/2007 – Disable Right Click in WorkBook

You can use the following function to disable mouse click "Right Click". This will disable popup menu:

Sub Disable_Right_Click()

' This will disable mouse right click on worksheets
Application.CommandBars("Cell").Enabled = False
End Sub

If you want to automate the workbook disabling right click when workbook is opened, use this alternative in ThisWorkbook module in VBE:

Private Sub Workbook_Open ()

' This will disable mouse right click on worksheets
Application.CommandBars("Cell").Enabled = False
End Sub

SOURCE

LINK

LANGUAGE
ENGLISH

7 thoughts on “Excel 2003/2007 – Disable Right Click in WorkBook”

  1. I simply could not depart your website prior to recommending which i very loved the conventional info a person provide for your visitors? Is destined to be back again frequently to check on up on brand new articles

  2. I am very influenced along with your site because smartly using the framework for your blog. Is that this a compensated theme or did you customize it your self? Either way keep up the superb high quality composing, it is unusual to determine a great blog like this one nowadays.

  3. To begin with, I wish to thanks in the stellar as well as educational access. I’ll need to admit which usually, I havent heard concerning this information. We now have noticed quite a few new information for cause. Thanks a lot for giving this effective as well as interesting info. We’re waiting pertaining to additional thrilling articles because of you against the closest long term.

  4. Marques Colston Jerseys Wonderful goods from you, guy. I have study your things ahead of as well as you are just as well amazing. I like what youve got the following, adore exactly what you are declaring and exactly how a person say it. You make it enjoyable and you nonetheless have the ability to help to keep it smart. We cannot wait around to go through additional of your stuff. That’s truly an amazing website. Marshall Faulk Jerseys

Comments are closed.