Replied 8 September 2017, 12:33 pm EST
I'm really sorry, but I don't have the time to create a small project for this issue.
I'm copying some code from my actual project, maybe that'll help. This was a custom menu I had created.
Private Sub LoadContextMenu()
Dim custommenu As New ContextMenu
custommenu.MenuItems.Add("&Cut", New EventHandler(AddressOf ContextMenu_Cut))
custommenu.MenuItems.Add("&Copy", New EventHandler(AddressOf ContextMenu_Copy))
custommenu.MenuItems.Add("&Paste", New EventHandler(AddressOf ContextMenu_Paste))
grdAnalysis.ContextMenu = custommenu
(where grdAnalysis is my Spread control)
This was showing up even in read-only mode.
But I've just figured out a way to stop it from showing up. When a sheet is readonly, I set grdAnalysis.ContextMenu = nothing. This works.
If you have any better suggestions, please let me know..otherwise this'll do!