View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 172
Default Put CommandButton1 code in Module1

CommandButton1.Value = true

"DocBrown" wrote in message
...
Is there a way to have the command button execution code in Module1
instead
of in the worksheet. Currently the CommandButton1 code is:

Private Sub CommandButton1_Click()
ListsUpdate
End Sub

Where ListsUpdate is a macro in Module1.