Disable the Right-Click Menu in a Worksheet

July 22nd, 2007

If for some reason, you need to disable the right click or shortcut menu in a worksheet, then you can place the code below in the code module of a worksheet.

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
    MsgBox "Sorry, right-click menus are disabled!"

End Sub

Posted in Excel, How To, VBA | No Comments




No Comments yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment



(C) by Virgilio Adriano. All rights reserved. Powered by WordPress.
Entries and comments feeds.
It took 0.378 seconds to load this page.