Simplify four macros to one button.

[gherzberg]

Is it possible to merge these 4 vba scripts into one macro so that they would all happen at the push of one button.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

THANKS!

[scottmoss]

Hi,

Could you not just call each sub within the on click event? so:

call CashSheet1
call TransferToSheet3
call Fee
call PL

The it will run them in that order.

[gherzberg]

You will have to forgive me, the person who built this book doesn't work here anymore and I am rather limited in my macro abilities. Would it look something like this?

Please Login or Register  to view this content.

[scottmoss]

Yes exactly like that (or below) then it will run each section when the other section has completed.

Please Login or Register  to view this content.

[gherzberg]

Thanks for the help