Put your Worksheet_Change() code into a macro in a regular code
module. Create a button on your sheet and attach the macro to it.
Click the button whenever you change the cell in the dropdown.

You may be able to automate the process if other cells calculations
depend on your dropdown cell. While a worksheet_Change event won't
fire in XL97, a worksheet_Calculate will. I can't tell from your
code exactly what you're looking for, so I don't know whether that
would be appropriate.




In article ,
"Gareth" wrote:

Sorry for being thick but a macro which does what and when would the button
be clicked?