I have a s-sheet that has 32 transparent buttons on it. Problem is that I need to change the procedure that is run on the buttons. When I record a macro I noticed that VBA is not declaring what button is being changed...
Is there a way to create a transparent CommandButton, so I can write a procedure that will change the script that is executed when it is clicked on? then switch it back to what is was.
The recorded code is below... I would rather have a CommandButton1, so I can select it point it to a different Sub, and then on a different day switch it back. Looking for a bit of direction.
Please advise and thanks. -R-
' SwitchCompletedOrdersForAMondayOnTheDashboard Macro
Selection.OnAction = "MDL_GetOnlyPastDueCompletedOrdersTodayMinusThreeDay"
' SwitchCompletedBackToTuesThruFriday Macro
Selection.OnAction = "MDL_GetOnlyPastDueCompletedOrdersTodayMinusOneDay"