Executing Macro Help

Hi there

I've got this combo box set up so that when I pick one scenario, it
executes a macro which changes a few values on the current ***.
However, this is a problem if I change worksheets and then change the
scenario, as it updates the values on that ***. What I'm looking to
do is change the scenario and execute the macro to change ONLY the
values on the tab that I want?

For example, I'm in Profits work*** and choose best scenario from
the combo box, and it changes B92 in Rev tab. Also, is there a way to
keep focus on the work*** and have it still execute the macro?

Any help would be greatly appreciated!

.