| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program Print Settings
Is there any method to set up the print settings for each sheet in a work
book to be the same as one of the sheets? Like a "paste special print settings" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Print Settings
WorkSheets.Select Worksheets("Master").Activate SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show activesheet.select Manually click on the first sheet, hold down the shift key and click on the last sheet. activate the "master" sheet, then do page setup. Make sure you ungroup your sheets (right click on the sheet tab and select ungroup.) -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Is there any method to set up the print settings for each sheet in a work book to be the same as one of the sheets? Like a "paste special print settings" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Print Settings
Thanks Tom - it worked as long as I did NOT do a
"Worksheets("Master").Activate" or the focus would then go off the grouped sheets Mervyn "Tom Ogilvy" wrote in message ... WorkSheets.Select Worksheets("Master").Activate SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show activesheet.select Manually click on the first sheet, hold down the shift key and click on the last sheet. activate the "master" sheet, then do page setup. Make sure you ungroup your sheets (right click on the sheet tab and select ungroup.) -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Is there any method to set up the print settings for each sheet in a work book to be the same as one of the sheets? Like a "paste special print settings" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Print Settings
I see that in Excel 2000 - even manually. In xl97 I don't believe that was
the case (your had to right click on the sheet tab and select ungroup if you had all the sheets selected). I guess you will have to make your master sheet the first in the tab order for this to work or do the selection using an array of sheet names. -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Thanks Tom - it worked as long as I did NOT do a "Worksheets("Master").Activate" or the focus would then go off the grouped sheets Mervyn "Tom Ogilvy" wrote in message ... WorkSheets.Select Worksheets("Master").Activate SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show activesheet.select Manually click on the first sheet, hold down the shift key and click on the last sheet. activate the "master" sheet, then do page setup. Make sure you ungroup your sheets (right click on the sheet tab and select ungroup.) -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Is there any method to set up the print settings for each sheet in a work book to be the same as one of the sheets? Like a "paste special print settings" |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Print Settings
This seemed to work ok in xl2002 no matter where Master was located.
Dim iCtr As Long Worksheets("master").Select For iCtr = 1 To ActiveWorkbook.Worksheets.Count Worksheets(iCtr).Select False Next iCtr SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show ActiveSheet.Select Tom Ogilvy wrote: I see that in Excel 2000 - even manually. In xl97 I don't believe that was the case (your had to right click on the sheet tab and select ungroup if you had all the sheets selected). I guess you will have to make your master sheet the first in the tab order for this to work or do the selection using an array of sheet names. -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Thanks Tom - it worked as long as I did NOT do a "Worksheets("Master").Activate" or the focus would then go off the grouped sheets Mervyn "Tom Ogilvy" wrote in message ... WorkSheets.Select Worksheets("Master").Activate SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show activesheet.select Manually click on the first sheet, hold down the shift key and click on the last sheet. activate the "master" sheet, then do page setup. Make sure you ungroup your sheets (right click on the sheet tab and select ungroup.) -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Is there any method to set up the print settings for each sheet in a work book to be the same as one of the sheets? Like a "paste special print settings" -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Print Settings
That is a excellent suggestion - I would see it synonymous to the array of
sheet names, but less work. <g -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... This seemed to work ok in xl2002 no matter where Master was located. Dim iCtr As Long Worksheets("master").Select For iCtr = 1 To ActiveWorkbook.Worksheets.Count Worksheets(iCtr).Select False Next iCtr SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show ActiveSheet.Select Tom Ogilvy wrote: I see that in Excel 2000 - even manually. In xl97 I don't believe that was the case (your had to right click on the sheet tab and select ungroup if you had all the sheets selected). I guess you will have to make your master sheet the first in the tab order for this to work or do the selection using an array of sheet names. -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Thanks Tom - it worked as long as I did NOT do a "Worksheets("Master").Activate" or the focus would then go off the grouped sheets Mervyn "Tom Ogilvy" wrote in message ... WorkSheets.Select Worksheets("Master").Activate SendKeys "{enter}" Application.Dialogs(xlDialogPageSetup).Show activesheet.select Manually click on the first sheet, hold down the shift key and click on the last sheet. activate the "master" sheet, then do page setup. Make sure you ungroup your sheets (right click on the sheet tab and select ungroup.) -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... Is there any method to set up the print settings for each sheet in a work book to be the same as one of the sheets? Like a "paste special settings" -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Print Settings
That's what I thought, too!
Tom Ogilvy wrote: That is a excellent suggestion - I would see it synonymous to the array of sheet names, but less work. <g -- Regards, Tom Ogilvy <<snipped |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Settings | Excel Discussion (Misc queries) | |||
| print settings | Excel Worksheet Functions | |||
| How do I save personal menu bar settings when closing program | Setting up and Configuration of Excel | |||
| Print Default settings | Excel Discussion (Misc queries) | |||
| Saving Print Settings? | Setting up and Configuration of Excel | |||
Linear Mode
