LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 557
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Group Shapes Zone Excel Programming 5 October 15th 06 11:52 AM
Stop rows from being deleted whilst allowing cells contents to cha SueD Excel Discussion (Misc queries) 2 August 22nd 06 02:59 PM
How to stop CommandButtons being deleted as pictures in code?? Corey Excel Programming 5 August 15th 06 12:18 PM
VB Code to stop cells being deleted T Jeanes Excel Programming 2 July 8th 04 01:05 PM
Stop Excel Updating formulas when cells are deleted? tom[_5_] Excel Programming 4 January 23rd 04 09:59 AM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"