View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alex J Alex J is offline
external usenet poster
 
Posts: 85
Default 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