Pause until I am ready

[Don2415]

I have a VBA code that opens a bunch of workbooks. I'd like to be able to manually manipulate the spreasheets and then have the code close and save the sheets. I see the "pause" command but it looks like i have to specify how long to pause. I don't know how long I want it to pause. Is there a way to make it stop running the code and then continue when I want it to?

 

[BSALV]

At the moment of the break, do you have variables in memory, that need to be remembered at the moment you restart ?

Or is it as easy as 2 commandbuttons, the 1st runs until the pauze/break.
You do your stuff and then you push the 2nd commandbutton ?

 

[bebo021999]

Sub ...
ip = inputbox(" Do you want to run now?"
If ip = true then
...running code

Lease the inputbox waiting until you finish work, come back then click OK

 

[Don2415]

At the moment of the break, do you have variables in memory, that need to be remembered at the moment you restart ?

Or is it as easy as 2 commandbuttons, the 1st runs until the pauze/break.
You do your stuff and then you push the 2nd commandbutton ?

It's the second case - the easy one!

 

[Don2415]

At the moment of the break, do you have variables in memory, that need to be remembered at the moment you restart ?

Or is it as easy as 2 commandbuttons, the 1st runs until the pauze/break.
You do your stuff and then you push the 2nd commandbutton ?

It's the easy second case.

 

[Don2415]

Sub ...
ip = inputbox(" Do you want to run now?"
If ip = true then
...running code

Lease the inputbox waiting until you finish work, come back then click OK

I tried this but as long as the inputbox is open, it will not let me work on the spreasheets

 

[BSALV]

if it's so easy, you can cut yourself your macro in 2 parts with their own commandbutton

 

[bebo021999]

Or:
Sub 1
...'code 1
call sub 2 ' pause sub 1 and working with sub 2
...code 2 ' continue