ExcelBanter - Command Button for Printing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Command Button for Printing (https://www.excelbanter.com/excel-programming/359116-command-button-printing.html)

create_share

Command Button for Printing

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

Tom Ogilvy

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???

All times are GMT +1. The time now is 03:23 PM.