I have a statement I'd like to print, which has a validation drop down list. The statement goes through calculations every time a different item is selected on the validation drop down list.
I'd like to be able to create a macro that selects all the items on the drop down list and prints the statement/sheet every time a different item on the drop down list is selected through the macro.
Basically, a print all version and having it stop once all the items have been selected and reset to the top of the drop down list.
Very new to macros. Running Vista SP 1, Excel 2003 SP3.
Thanks
Jason
I'd like to be able to create a macro that selects all the items on the drop down list and prints the statement/sheet every time a different item on the drop down list is selected through the macro.
Basically, a print all version and having it stop once all the items have been selected and reset to the top of the drop down list.
Very new to macros. Running Vista SP 1, Excel 2003 SP3.
Thanks
Jason