View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aggie94 Aggie94 is offline
external usenet poster
 
Posts: 2
Default Assign Sub to Custom Button

How can I assign a particular Sub to a button that I create
programmatically? In other words, I have created a subroutine that will
create a custom toolbar and buttons on the user's computer. It will created
(if it does not exist) or be made visible when a particular workbook is
opened and hidden when the workbook closes. How do I assign other
subroutines to those custom buttons through the programming? None of the
buttons will be for existing Excel functions.