Disable selection of shapes
A partial solution is a "Null" subroutine, like the following:
Sub ClickMe()
End Sub
This has the effect of nullifying the mouse left-click selection function
very nicely. Unfortunately, I know of no way to prevent the right-click
selection. If someone in the NG knows how to capture right-click event for a
shape, we might have a full solution here.
HT(partially)H,
Alex J
"Jim Rech" wrote in message
...
The only way I know of to prevent shapes from being selected is to protect
the worksheet (Tools, Protection, Protect Sheet).
--
Jim Rech
Excel MVP
|