Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Pop up menus in Excel

I want to hide or disable the pop up menu that appears everytime i
right click a worksheet tab. is this possible?

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default Pop up menus in Excel

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

--
Cheers,
Shane Devenshire


" wrote:

I want to hide or disable the pop up menu that appears everytime i
right click a worksheet tab. is this possible?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull down menus possible in excel? bwallan Excel Discussion (Misc queries) 1 January 20th 06 06:56 PM
making your own menus on excel? TAL27 Excel Discussion (Misc queries) 2 January 19th 06 03:47 PM
New Menus - attaching but menus are reset Greegan Excel Worksheet Functions 0 November 5th 05 03:19 PM
Can I put Pop up menus on Excel Ricardo Munoz Excel Worksheet Functions 2 February 24th 05 03:47 PM
drop down menus in excel rowing coach Excel Discussion (Misc queries) 1 December 4th 04 12:25 AM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"