Thread: Private Sub - Hot key?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default Private Sub - Hot key?
The Application.OnKey method sets up a procedure to run when a certain key
(or combination) is pressed:
Application.OnKey(Key, Procedure)
for full details see Excel VBA help file.

"Arturo" wrote:

is there a way to assign a hot key to a Private Sub?
Reply With QuoteReply With Quote