I have a shortcut (Ctrl-M) that changes the display to a sheet called "Select". In addtion I would also like to have it click a commandbutton that is on the displayed sheet.
When I record a macro, it does nor record anything when I click on a commandbutton.
It is an action that is performed many, many times per day and it would reduce the number of clicks a user would have to perform.
Here is the workbook code
When I record a macro, it does nor record anything when I click on a commandbutton.
It is an action that is performed many, many times per day and it would reduce the number of clicks a user would have to perform.
Here is the workbook code
Code:
Private Sub Workbook_Open()
Application.OnKey "^m", "Display_Select" '<- Ctrl + m
End Sub