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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com