Showing posts with label How to disable right click menu control in excel book. Show all posts
Showing posts with label How to disable right click menu control in excel book. Show all posts

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

Recent Posts

Trending Topic

Breaking

Related Post No.

Pages