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 |
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 |
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 |
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