You're probably not going to find a better solution thatn the Combo box one
.....
--
Time is just the thing that keeps everything from happening all at once


"Loopi" wrote:

Not currently using combo boxes. The workbook is linked to 12 individual
workbooks across a network. User looks at desired information by selecting
the month of interest. Using indexing, tables and charts that are viewed are
set to display the month selected with a conditional formatting dropdown.
Currently the sheet is forced to update all 12 links upon open. This update
across the network takes a long time. I would like to let the user hit a
button after selecting the desired month and update only the one link saving
a lot of wait time. I know how to do the button thing and all of that but I
want the macro to detect what month the user has selected and update the link
to the sheet for the corresponding month

Thank you