On Button Click Run A Module Then Wait Till Complete Then Run Another Module...

Hi Guys!


I have button on my worksheet.

I have 3 separate VBA Modules called

1) paste

2) pre

3) clear


How do i get my button to do the following for that Worksheet only when cicked.


* Call module "paste"

* Wait Unitl That Module Have Finished Executing

* Call module "pre"

* Wait Unitl That Module Have Finished Executing

* Call module "clear"

END


Any help appreciated guys, i have coded the modules as was told i could do the above using a Button Click command somehow??