create a button that previews sheets
 

Hi,

Yesterday I learnt how to create a button to Print my sheets. Now I'm
wondering if there is a way to create button that will open the sheets in
Preview?

Thanks,

Helen

create a button that previews sheets
 

Hi Helen,

Try:

'==============
Private Sub CommandButton2_Click()
Sheets(Array("Sheet1", "Sheet2")).PrintPreview
End Sub
'<<==============


---
Regards,
Norman



"Helen" wrote in message
...
Hi,

Yesterday I learnt how to create a button to Print my sheets. Now I'm
wondering if there is a way to create button that will open the sheets in
Preview?

Thanks,

Helen