Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2007

Tip: Looking for answers? Try searching our database.

Pop up menus in Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
uglydennise@gmail.com - 15 Feb 2007 00:15 GMT
I want to hide or disable the pop up menu that appears everytime i
right click a worksheet tab. is this possible?
ShaneDevenshire - 19 Feb 2007 08:39 GMT
Yes, but you must add VBA to your workbook.  Specifically, you need to add
the BeforeRightClick event:

You can put this into the module of the sheet where you want to disable
right-click:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
   Cancel = True
End Sub

Or you can add the following code to the thisWorkbook module:

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target
As Range, Cancel As Boolean)
   Cancel = True
End Sub

Signature

Cheers,
Shane Devenshire

> I want to hide or disable the pop up menu that appears everytime i
> right click a worksheet tab. is this possible?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.