Print Settings
I have several forms on my worksheet (that are set up as named ranges) that I
wish to print separately, by using a macro button. I have no problems with
setting up the maco and button, but I cannot get the page setup to save to
the named range. When I go through Page Setup and print it manually it works
fine...as soon as I change the Page Setup for the other form, the print
setting revert to the settings for that form for the current one.
Is there a way to assign Page Setup settings to a certain named range?
I hope someone can help.
|