What is this context menu and how can I remove it, please?

Batbloke

New Member
Joined
May 18, 2022
Messages
13
Office Version
  1. 365
Platform
  1. Windows
Hi all
In my vba macro I have set it so only certain cells can be selected (the ones within the brown border)
I have turned off cell right-click context menu
I have disabled drag and drop etc. (Application.CellDragAndDrop = False)
I thought I had unwanted user-mouse fiddling cracked, until (acting as a user would), I selected two (or more) cells that contained data (strings in this case).

Then this little beastie appeared at the bottom-right edge of the selection:
WhatThis1.jpg

Clicking on it, produced this:
WhatThis2.jpg

I can't seem to find a reference to it anywhere, but not knowing what it's called doesn't help.
How can I prevent this from appearing please?
The sheet is locked, with only Select unlocked cells selected
I have also set the scroll area:
goXsTT.ScrollArea = "C3:" & UTColumnNumToAlpha(giTableEWColQty + 2) & _
Trim(CStr(giTableNSRowQty + 2))
Tip: Setting the scroll area also makes cells outside of that area un-selectable

Appreciate any help, thanks in advance.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
I'm still none the wiser, but I've found that including ActiveCellOffset(0, 0) stops that potential wrecker from appearing.
I'd still like to know what it's called please and how to properly turn the thing off, note that NONE of the Options, advanced or otherwise make any difference.
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If frmTerrain.Visible = True Then
        frmTerrain.cmdLay.Picture = LoadPicture(gsGeneralImagePath & "SW.jpg")
        frmTerrain.cmdLay.Enabled = True
        frmTerrain.chkOverlay.Enabled = True
        ActiveCell.Offset(0, 0).Activate
    End If
End Sub

Microsoft Excel 365 VBA v7.1
 
Upvote 0
You can disable the quick analysis tool as follows...

VBA Code:
File >> Options >> General >> uncheck 'Show Quick Analysis Options on Selection'

Hope this helps!
 
Upvote 0
Solution
You can disable the quick analysis tool as follows...

VBA Code:
File >> Options >> General >> uncheck 'Show Quick Analysis Options on Selection'

Hope this helps!
Many thanks! That must have been the one and only option checkbox I didn't try. Now knowing what it is called, I've found the application code:
VBA Code:
Application.ShowQuickAnalysis = False
Again, many thanks. DG
 
Upvote 0

Forum statistics

Threads
1,214,987
Messages
6,122,618
Members
449,092
Latest member
amyap

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top