How to disable right click menu control in excel book

How to disable right click menu control in excel book

Step-1 go to excel vba editor
           go to this this workbook page
          
check below image and paste code

-----------------------------------------------------------------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("cell").Controls("copy").Enabled = True
Application.CommandBars("cell").Controls("cut").Visible = True
End Sub

Private Sub Workbook_Open()
Application.CommandBars("cell").Controls("copy").Enabled = False
Application.CommandBars("cell").Controls("cut").Visible = False
End Sub
----------------------------------------------------------------------------------------

About Me

author Click here for Connect FB

Click here for Linkedin

Related Post No.

Powered by Blogger.

Contact Form

Name

Email *

Message *

Search This Blog

Recent Posts

Breaking

Popular Posts

Recent Posts

Trending Topic

Breaking

Related Post No.

Pages