Macro to create validation list of worksheet names
I have a large workbook consisting of a €śmenu€ť worksheet and many worksheet
templates. On the €śmenu€ť worksheet, I want to enable the user to select the
particular worksheets they need for their job from dropdown lists contained
in cells B1:B25. The names of the worksheet €śtemplates€ť are subject to
change. In other words, the user may add a new duplicate template worksheet
to the workbook or they may change the names of any of the existing
templates. On the €śmenu€ť, I want a macro that will create a dropdown list in
each of cells B1 through B25 that includes all the current worksheet names in
the workbook except for a selected few that Ill call €śmenu€ť, €śWorksheet X€ť,
€śWorksheet Y€ť, and €śWorksheet Z€ť. If possible, I would like to have the user
be able to hyperlink from their dropdown list to the selected worksheets.
I dont have much experience with vba therefore any help to a novice would
be greatly appreciated.
Many thanks in advance €“ Tom.
|