Does anyone know how to do the following in VB Excel.
A single command button when pressed selects all 3 worksheets within a
spreadsheet and then displays the print menu? Or at least selects the 3
worksheets and prints out all the pre selected print areas?

Each time I attempt this I get an error even when all the correct printers are
attached.
Private sub commandbutton1_click()
worksheets (array(1,2,3)).select
worksheetss(1).activate
worksheets.printout
end sub

Hope this makes sense and can anyone help?