View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Command Button for Printing

Private Sub Commandbutton1_click()
Range("B9:Z30").Printout
End Sub

--
Regards,
Tom Ogilvy


"create_share" wrote:

I want to use a Command Button for Print Command without the printing dialog
box and for specific area. Can anybody help me???