Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Print Settings Across Entire Workbook Nia Excel Discussion (Misc queries) 3 April 3rd 23 01:25 PM
Can Excel settings default to always print entire workbook? evie Excel Discussion (Misc queries) 1 December 15th 06 12:21 AM
How do I stop Excel print settings from transfering? Albertsons Erik Excel Discussion (Misc queries) 0 December 5th 05 09:54 PM
excel 2003 changing saved print settings George Applegate Excel Discussion (Misc queries) 0 November 1st 05 06:50 PM
Applying Print Settings to Several Spreadsheets At Once JR_06062005 Excel Discussion (Misc queries) 1 August 3rd 05 02:47 PM


All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"