ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent User from Deleting Drawn Object (https://www.excelbanter.com/excel-programming/304772-prevent-user-deleting-drawn-object.html)

tod

Prevent User from Deleting Drawn Object
 
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

Chip Pearson

Prevent User from Deleting Drawn Object
 
Tod,

I don't believe it is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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




Vic Eldridge

Prevent User from Deleting Drawn Object
 
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


Dave Peterson[_3_]

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


Ivan F Moala[_3_]

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



All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com