Steps within a recorded macro

[robbyn]

Does lO/ OO only step through a macro when each entry has given feedback that it has been completed?

I have this problem with Shift Ctrl F9. It takes a long time to complete updating a particular spreadsheet. I had put it at the start of a macro and was wondering why the macro does not seem to have run. I am wondering if the rest of it did run but had no effect because the update was still in progress.

[Zizi64]

Please upload an ODF type sample file here, together with the embedded recorded macro.

[John_Ha]

Does lO/ OO only step through a macro when each entry has given feedback that it has been completed?

Probably.

I am sure you can single step through a macro - see controls in image where you can also set breakpoints.

Clipboard01.gif (9.84 KiB) Viewed 1533 times

Or test by adding multiple message boxes in the macro asking you to allow it to continue to see how it progresses. Use something like

Code: Select all

rem ----------------------------------------------------------------------
' MsgBox("Prompt", buttons, "Title")
' buttons = 1 ... means 2 buttons - OK  (resp = 1) and CANCEL (resp = 2)
' buttons = 4 ... means 2 buttons - YES (resp = 6) and NO     (resp = 7)
rem ----------------------------------------------------------------------

   response = MsgBox( "Continue?",4,"Position in macro")  ' YES and NO buttons

   If (response = 6) Then                  '  6 = YES, I want to continue
   ...
   Else                                    '  7 = NO, I want to stop
   ...
   EndIf