Hi, Loobrush,
to my opinion re-think the layout of the workbook. You choose Form-controls for each option - I might have taken an UserForm from VBA with a Listbox (for the names of the sheets) and MultiSelect 2-frmMultiSelectExtended for an array of choices or a ComboBox.
If you want to stay with your form-controls (I think you selected the cells in row 2 for the sheet names) maybe change the code to read
and call the changed macro from within every macro you have created so far. Please note that the cell values have to be equal to the sheetnames (I tested with I2 and a run time error was raised as the cell shows 'Manual Milling' while the sheet is called 'ManualMilling').
Ciao,
Holger
Bookmarks