Pausing everything until another Macro is run

Hi - I have some code that copies across an image and I need to pause everything until the user selects the image which then removes it from the sheet. I don't want the user to be able to do anything on the sheet until the Image has been removed.

I need to first macro to Pause until the user clicks the image (which has the 2nd macro assigned to it) - So need the code that goes at the end of Show_Help_Image

Can anyone help??

Many thanks in advance...

Here is my code....

Please Login or Register  to view this content.

.
.
If I understand your question correctly ... call the second macro from within the first macro, where you want the first macro to pause.
When the second macro is complete ... it should return to the same point in macro one.

Sub MacroOne()
do something

do something

do something

call MacroTwo '<-- goes to second macro

'<-- returns here

do something
do something
End Sub

Sub MacroTwo()
do something
do something
End Sub '<--- goes back to macro one