right-click

I would like to ask you about the groups in a pivot table. You easily create one group by selecting for example 5 from 6 columns headers (or rows, of course) in the pivot table and right-click - group. From this point and then: If I see a grouped pivot table how can i know which columns it...

I do a lot of coding for the event right-click. I end my additional steps with Cancel=True which used to always avoid popping up the incell menu. Now, for the past many months, the cancel=true seems to no longer work and I get an annoying right-click menu that pops up after my code executed...

This code will prevents users from right-clicking ON THE TAB itself: Application.CommandBars("Ply").Enabled = False but it only works if the user tries to right-click a SINGLE tab. If they select more than one tab and right-click, they are still able to do so. Is there some code...

So MS has renamed the old Comments to Notes, and the new Comments have become threaded conversations. We're now using Notes in the same manner as we used to use Comments. The problem is, EDIT NOTE nor NEW NOTE appear in the right-click menu when in a cell that has a Note, only DELETE NOTE. Is...

I would like to disable the ability for the user to right-click on any of the sheet tabs in a particular workbook. I ran across a web page that talked about how to do it, using this code in the ThisWorkbook module: <code class="vb keyword"> Private</code> <code class="vb keyword">Sub</code>...

I have written a VBA procedure in Excel 2010 that tries to hidden commandbars and prevents several actions from the user. I have included and run this code: Dim Cbar As CommandBar For Each Cbar In Application.CommandBars Cbar.Enabled = False Next Now, when I opn ANY excel...