I have a command button on my worksheet.
When it is clicked an event procedure executes.

Q1) How do I assign a keyboard shortcut to this button so I don't have to click it?

I have solved this by making the Private Sub CommandButton1_Click into Static so it appears in the standard macro list and then I assign a shortcut

- but is this the correct way to do it, are there any better/easier ways ?



Q2) How do I assign the shortcut CTRL F1 to the button ?

When the sheet it is finished it will be protected and users will not need access to Format Cells. I cannot seem to get assign CTRL+F1 to a macro (or any function key for that matter) - is it possible?


Any help appreciated folks!