Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent deleting functions | Excel Discussion (Misc queries) | |||
Prevent deleting multiple cells at once | Excel Discussion (Misc queries) | |||
How can I prevent someone from deleting a shared workbook? | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) |