save the print settings when i use save as command

[skalavati]

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]

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]

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.