View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Prevent User from Deleting Drawn Object

Or maybe protect it (and the sheet).

The provide a macro that asks where to move it???

Let your macro do the real work of unprotecting, moving, and reprotecting.

Tod wrote:

The worksheet has a Star shape on it. The user needs to be
able to move it around, so I have it unlocked when the
sheet is protected. Fine. However, it does not prevent the
user from deleting the shape. Is there a way to allow the
user to move the shape around and not delete it?

tod


--

Dave Peterson