Im looking to run multiple macros, not just one. How do I change this code to do that?
This code works but only runs one macro. I want to run multiple.
Sub Btn_Click()
Select Case xlOn
Case ActiveSheet.[Check Box 12].Value
LegendPlatesSht1
Case ActiveSheet.[Check Box 13].Value
LegendPlatesSht_1
Case ActiveSheet.[Check Box 14].Value
LegendPlateSht2
Case ActiveSheet.[Check Box 15].Value
StandardLegendPlates1
Case ActiveSheet.[Check Box 16].Value
MedDeviceTagsSingleLine
Case ActiveSheet.[Check Box 17].Value
CallMediumDeviceTagsDualLine1
Case ActiveSheet.[Check Box 18].Value
SmallDeviceTags
Case ActiveSheet.[Check Box 19].Value
MedMtrTag300
Case ActiveSheet.[Check Box 20].Value
MedMtrTag325
Case ActiveSheet.[Check Box 21].Value
MedMtrTag350
Case ActiveSheet.[Check Box 22].Value
MedMtrTag375
Case ActiveSheet.[Check Box 23].Value
LargeULPanelTag
Case ActiveSheet.[Check Box 24].Value
LargePanelTag
Case ActiveSheet.[Check Box 25].Value
SmallPanelTag
Case ActiveSheet.[Check Box 26].Value
SWSerialMDLtag
Case Else
MsgBox "Please Check one of the boxes"
End Select
End Sub
Any help here is progress. Thanks
Bookmarks