Hi, begin recording a macro that does what you are trying to do. Then
add a command button and right click it change the name and caption
properties to your suite your needs. Double click on the button (in
design view) and the code window will pop up with similar code:
Sub CommandButton1_Click()
'Enter the following line
Call 'your macro name here'
End Sub

Hopefully, this gives you a place to start--Lonnie M.