save the print settings when i use save as command

skalavati · May 10th, 2002, 11:54 PM

the print and page settings do not get saved when i use save as, what is to be done let me know asap it wud be of great help.

Juan Pablo González · May 11th, 2002, 08:57 AM

What do you mean Print and Page settings ?

The Page setup is saved at workbook level, that means, each sheet remembers it's page setup settings.

About printing setup, do you mean, number of copies, what order, which pages, that stuff ?

Colo · May 11th, 2002, 10:43 AM

Hi skalavati,
You mean page settings of printer driver?
If so, it is not able to save.

As my idea, Add one more same printer (for "the sheet") on control panel, and when you want to print "the sheet" , switch printer by vba.

May 11th, 2002, 08:57 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	What do you mean Print and Page settings ? The Page setup is saved at workbook level, that means, each sheet remembers it's page setup settings. About printing setup, do you mean, number of copies, what order, which pages, that stuff ? __________________ Regards, Juan Pablo González http://www.juanpg.com

May 11th, 2002, 10:43 AM	#3
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hi skalavati, You mean page settings of printer driver? If so, it is not able to save. As my idea, Add one more same printer (for "the sheet") on control panel, and when you want to print "the sheet" , switch printer by vba. __________________ Regards, Masaru Kaji aka Colo - Ex Microsoft MVP Since 2004 -2009

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 11:54 PM	#1
skalavati Board Regular Join Date: Apr 2002 Posts: 55	the print and page settings do not get saved when i use save as, what is to be done let me know asap it wud be of great help.