Re: Executing Macro Help

not sure what you mean either:

1. when you execute the code on the combobox change, activate the *** you want
then execute the code
2. qualify the ranges with the *** name, so when the code executes, it always
references the cells that ***.

--


Gary


<alexdetrano@xxxxxxxxx> wrote in message
news:1177991825.761630.120290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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!



.