Here is a simple way to disable the Cut & Copy in the Popup menu
Sub Disable_Buttons()
Dim oC1 As CommandBar
Set oC1 = Application.CommandBars("CELL")
oC1.Controls("Cu&t").Enabled = False
oC1.Controls("&Copy").Enabled = False
End Sub
Other menu items can also be handled similarly
To disable the Insert & Delete in the Popup menu
oC1.Controls("&Insert...").Enabled = False
oC1.Controls("&Delete...").Enabled = False
Sunday, August 12, 2007
Error loading feed.
Error loading feed.
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Error loading feed.
No comments:
Post a Comment