Thread: Assign button to run macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
  
Posts: 1
Default Assign button to run macro
In ThisWorkbook:

Application.OnKey "{F1}", "UnHide"

Where "F1" is the button you're assigning the macro to and "UnHide" is
the name of the macro. Lookup "OnKey" in VBA Help for a list of the
keys names to use. - Pikus


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote