Thread
:
Prevent User from Deleting Drawn Object
View Single Post
#
5
Posted to microsoft.public.excel.programming
Ivan F Moala[_3_]
external usenet poster
Posts: 38
Prevent User from Deleting Drawn Object
Hi Tod, is there any purpose/reason for a Star ?
Anyway you could use a Userform Shaped like a Star (just thinking out side)
For code to changing shapes of userforms see here...includes Star shape.
http://www.xcelfiles.com/FormsSearch.html
(Vic Eldridge) wrote in message om...
Tod,
From what I can see, the following menu items can be used to
delete a shape.
Edit Cut
Edit Clear All
Right click Cut
All these menu items can be re-directed to your own macro that
checks what is selected before performing a delete. If your star
shape is selected, bail out, otherwise delete whatever is selected.
A shape can also be deleted using the Delete key, and also Ctrl+X.
Application.Onkey can re-direct those to your special delete macro too.
Regards,
Vic Eldridge
"Tod" wrote in message ...
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
Reply With Quote
Ivan F Moala[_3_]
View Public Profile
Find all posts by Ivan F Moala[_3_]