Aswell as clicking a button on the spreadsheet, my users want to be able to press one of the Function Keys or a Control-Function Key to achieve the same thing. So I thought of using a Macro that responded to a Function Key but I couldnt get it to run the Sub button_click() code that the button runs.
Is there another way to trap when a user presses F8 or Control-F8 and then call this sub ?
Thanks Bill
Is there another way to trap when a user presses F8 or Control-F8 and then call this sub ?
Thanks Bill