Managing execution of Multiple Buttons (Macros)

[Bovey44]

Upon opening a specific workbook, I have 5 separate buttons that execute specific macros. I'd like to be able to choose any one of them, have the associated macros run to completion and then revert back to the opening worksheet where I can choose another button. I've tried several solutions including setting events, etc., but no luck. Each time I click on any one of the buttons I get the result intended, but cannot get back to the opening worksheet and choose another. Any assiatnce would be appreciated. Thank you.

 

[Logit]

If you opening worksheet were SHEET1 ....

Sheet1.Activate

 

[Bovey44]

If you opening worksheet were SHEET1 ....

Sheet1.Activate

Hi Logit - I tried what you suggested and it didn't compile (BTW, when opening the workbook it's on a tab entitled "Buttons") - I also tried to qualify it with: ActiveWorkbook.Worksheets("Buttons").Activate but, that didn't work either. I'm new at this - I hope that I explained myself properly.

 

[Logit]

Best bet is to post your code. You should also consider placing your workbook on a CLOUD site for download. www.dropbox.com is a sample cloud site. Post the address for downloading the workbook.

 

[Bovey44]

Hi Logit - my error - I retried what you suggested and it worked w/o any problem. Thank you.

 

[Logit]

You are welcome.