| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel color-formatted text previews & prints in black | Excel Discussion (Misc queries) | |||
| create button that can hide/unhide sheets and hyperlink... | Excel Programming | |||
| Create a Button that will print sheets | Excel Programming | |||
| Create floating button based on button click in menu | Excel Programming | |||
| slow page break previews | Excel Discussion (Misc queries) | |||
Linear Mode
