Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2022, 01:58 PM
ksor ksor is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2016
Advanced Beginner
Catch Shape.Before_Delete ???
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default Catch Shape.Before_Delete ???

I have a WorhSheet with a lot of shapes.


To each shape is "attached" a Word-file telling some specifics about the shape.
All these Word-files are place in a folder.


Now I want to Delete the Word-file 'attached' to the shape I delete.


I can't find any Shape(Name).Before_Delete().


How can this be done - the KISS way ?

Last edited by ksor; 12-01-2022 at 10:46 PM.
Reply With Quote
  #2  
Old 12-02-2022, 12:07 AM
ksor ksor is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2016
Advanced Beginner
Catch Shape.Before_Delete ???
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Unhappy

Really - no one knows how ?


I know how to delete the Word-file - it's just how to CATCH the Before_ or After_DeleteShape I'm looking for.


I just want to catch the user selecting a shape and then press the Delete-key on the keyboard.
Reply With Quote
  #3  
Old 12-02-2022, 12:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by ksor View Post
Really - no one knows how ?

A this is a FREE forum manned by volunteers all over the world, you can not expect to get answers immediately. Free forum courtesy is waiting about 24 hrs before bumping.
If you are in a hurry there are pay sites which will be gad to oblige.
Good luck with your query
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 12-02-2022, 11:27 PM
ksor ksor is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2016
Advanced Beginner
Catch Shape.Before_Delete ???
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

OK, that's fair !


I wonder why I didn't get message about your reply ??


I've set it to "Instant email notification"
Reply With Quote
  #5  
Old 12-03-2022, 12:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by ksor View Post
I wonder why I didn't get message about your reply ??


I've set it to "Instant email notification"

You'll have to check that with a mod (Macropod ?) or admin
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 12-05-2022, 01:54 AM
Guessed's Avatar
Guessed Guessed is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't think there is a simple way. It might be possible if you create a Class Module and attach an event to it that way. I very rarely do Class modules so I would have to point you towards other information sources which might get you started such as:
Excel shapes events: how to track user actions – C# sample add-in
https://www.excelanytime.com - Excel VBA Custom Classes & Objects, Class Modules, Custom Events
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 12-06-2022, 04:29 AM
ksor ksor is offline Catch Shape.Before_Delete ??? Windows 10 Catch Shape.Before_Delete ??? Office 2016
Advanced Beginner
Catch Shape.Before_Delete ???
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
I don't think there is a simple way. It might be possible if you create a Class Module and attach an event to it that way. I very rarely do Class modules so I would have to point you towards other information sources which might get you started such as:
Excel shapes events: how to track user actions – C# sample add-in
https://www.excelanytime.com - Excel VBA Custom Classes & Objects, Class Modules, Custom Events

THX - I think the second of your links is worth a closer look
Reply With Quote
Reply

Tags
shates deleting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
When I copy a shape into another document it becomes a picture. I want a shape. FJM Word 4 02-24-2022 09:59 AM
Catch email message for processing jordias Outlook 0 08-23-2021 08:09 AM
Fit text to shape / Place table in shape Floppy PowerPoint 0 04-01-2021 11:01 AM
How to change size / shape of a shape in a stencil tomgoodell Visio 1 06-30-2016 04:40 AM
Catch event before next slide PetLahev PowerPoint 0 10-21-2011 03:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft