Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Entire Workbook
Hi,
I'm trying to set the default for excel docs to always default to print "entire workbook" when it is printed. Is there a registry entry that I can add or edit for this that anyone know about? Or even a command line option? Thanks Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Entire Workbook
Maybe you could use a macro:
Option Explicit Sub PrintWorkbook() ActiveWorkbook.PrintOut End Sub And then run that macro whenever you want to print the entire workbook. (I've never seen a way to change that dialog to default to entire workbook.) Rob Hudson wrote: Hi, I'm trying to set the default for excel docs to always default to print "entire workbook" when it is printed. Is there a registry entry that I can add or edit for this that anyone know about? Or even a command line option? Thanks Rob -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Entire Workbook
Thanks for taking the time to reply. Unfortunately I can't use the macro as I need to be able to print it without opening the document (This is required for an automated process) Thanks Rob "Dave Peterson" wrote: Maybe you could use a macro: Option Explicit Sub PrintWorkbook() ActiveWorkbook.PrintOut End Sub And then run that macro whenever you want to print the entire workbook. (I've never seen a way to change that dialog to default to entire workbook.) Rob Hudson wrote: Hi, I'm trying to set the default for excel docs to always default to print "entire workbook" when it is printed. Is there a registry entry that I can add or edit for this that anyone know about? Or even a command line option? Thanks Rob -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Entire Workbook
Good luck.
If you find a solution, please post back. Rob Hudson wrote: Thanks for taking the time to reply. Unfortunately I can't use the macro as I need to be able to print it without opening the document (This is required for an automated process) Thanks Rob "Dave Peterson" wrote: Maybe you could use a macro: Option Explicit Sub PrintWorkbook() ActiveWorkbook.PrintOut End Sub And then run that macro whenever you want to print the entire workbook. (I've never seen a way to change that dialog to default to entire workbook.) Rob Hudson wrote: Hi, I'm trying to set the default for excel docs to always default to print "entire workbook" when it is printed. Is there a registry entry that I can add or edit for this that anyone know about? Or even a command line option? Thanks Rob -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set print area for entire workbook | Excel Discussion (Misc queries) | |||
Set 'Print Entire Workbook' as default? | Excel Worksheet Functions | |||
set default to print out the entire workbook | Setting up and Configuration of Excel | |||
Set 'Print Entire Workbook' as default? | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) |