View original (French)

Context menu suppression by right-click in Excel

Solved
supermoun -  
Hello everyone,

Is it possible, when opening an Excel workbook, to remove the right-click context menu in one or more sheets?

Thanks for the answer
Configuration: Windows XP Firefox 2.0.0.12

3 answers

  1.  gbinforme Contributor
    hello

    remove the right-click menu from the mouse in one or more sheets.

    To remove it on all sheets, put this in thisworkbook 
    Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub

    To remove it on a single sheet, put this in each concerned sheet 
    Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub

    --

    Always zen
    2
    1. supermoun
      Hello GBinforme,

      Excuse the delay.

      I tried it in the sheet, it’s ok.

      For the workbook, it doesn’t work.

      See you later
      0
  2. gbinforme Contributor
    hello

    for the workbook, it doesn't work.

    You surprise me a lot and verify that you have Workbook_SheetBeforeRightClick( in the VBA sheet of thisworkbook
    --

    Always zen
    0
    1. supermoun
      Hello GBinforme,

      It's good for the binder.

      See you.
      0
  3. gfortin9
    Hello!

    Sorry, interpretation error 8- /

    Tourlou...
    0