how to run macro for all sheets in a workbook

[initialcondition]

Hi guys;

I have a macro embedded in a sheet with a control form button. it works well for that sheet. I want to use it for other same sheets in that workbook. How should I configure my macro so that it runs for all same sheets in workbook in one push ? I want to run the macro only in first sheet and it must solve all the similar sheets.

I use excel 2010, it is easy to make new tabs in this version. Maybe it is good idea to create a new tab with this macro and make it possible to run for whole workbook ?

p.s. I have found some codes in internet to run a macro in several sheets in a workbook. I embedded my code in their algoritm, but none of them works. They only solve the first sheet, no effect on other sheets

thanks for answers.

[Domski]

Can you post your code so we can see what it's doing?

Dom

[initialcondition]

Please Login or Register  to view this content.

[Domski]

I'm not too hot on coding Solver as I rarely use it but you could try activating each worksheet before running the solver code otherwise it'll just run loads of times on the worksheet you've got active I think.

Please Login or Register  to view this content.

Probably not the best approach but worth a try.

Dom

[initialcondition]

Yes, Domski you are right,
it works now.
Thank you a lot for solving my problem.