Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Stop to Group of Shapes to be deleted
Hi all, I got few rectangle shapes on my worksheet which been grouped
together and I gave a name of "Shp" to that group. I want macro to put in Worksheet Module that if someone try to delete that group of shapes by selecting that group and press delete on keyboard then a Msgbox should appear saying "Can not be Deleted" and that group should not be deleted. Please can any friend can help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Stop to Group of Shapes to be deleted
Why not "protect" your objects.
Format, Protection. Check/uncheck "Lock" as required. Under Tools, Protection, tick all the options then untick Edit Objects (assuming there's nothing else you want to protect), and Protect. With earlier versions of Excel, in the Protection dialog just tick "Objects". There is no simple way to intercept the user's attempt to delete objects and prevent deletion. Regards, Peter T "K" wrote in message ... Hi all, I got few rectangle shapes on my worksheet which been grouped together and I gave a name of "Shp" to that group. I want macro to put in Worksheet Module that if someone try to delete that group of shapes by selecting that group and press delete on keyboard then a Msgbox should appear saying "Can not be Deleted" and that group should not be deleted. Please can any friend can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group Shapes | Excel Programming | |||
Stop rows from being deleted whilst allowing cells contents to cha | Excel Discussion (Misc queries) | |||
How to stop CommandButtons being deleted as pictures in code?? | Excel Programming | |||
VB Code to stop cells being deleted | Excel Programming | |||
Stop Excel Updating formulas when cells are deleted? | Excel Programming |