Thread: Print Settings
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dale Dale is offline
external usenet poster
 
Posts: 92
Default 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.