Conditional macros

Hi,

Is it possible for macro to run only if the other macro has been run fully ? I’ve multiple command button set in a worksheet, 1 to print AJ’s another one to clear all contents, is it possible for clear all contents macro should only work when print macro has been called fully. If print macro hasn’t been run fully then message box appears for the user to print documents first.

Thank you in advance.

??? e.g.:

Please Login or Register  to view this content.

Thank you - it’s not working for some reason
Let me try and explain in detail

Macro 1 is - print document
Macro 2 is - clear document

Both working fine - but I want to macro 2 to check if macro 1 has run fully before clearing the document. If macro 1 not run fully then stop the process and show message box.

Thank you

Is Macro 2 always clear after Macro 1?

If so
Make Macro 2 as Private and run Macro 2 from Macro 1 after the print.

Originally Posted by samarbac

... I want to macro 2 to check if macro 1 has run fully ...

That's how it works.
If the variable "prmsn" does not get the value "True" (prmsn = True) when executing "procedure_1", then "procedure_2" will not be executed.

Originally Posted by samarbac

it’s not working for some reason

Give an example of your procedures.

Hi

Thank you for the message- here is my 2 macros : I want 2nd macro to only works if 1st macro of PDF has fully run :

Macro One :

Please Login or Register  to view this content.

2nd Macro

Please Login or Register  to view this content.

Thank you

Hi

thank you for the reply.

Unfortunately, it's not doing anything - like when I try and save PDF - it brings up windows for location and when click save - it doesn't save. Also, when click on Newday macro it shows the message box of procedure not completed fully and then that's it.