Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Copy printer setup to new sheet in workbook

Using Excel 2003. I create a new sheet every month (monthly health calendar).
I can copy the contents of the previous month as a starting point, but I have
to enter the printer setup info from scratch every time - very tedious. Is
there a way I can set the printer parms for the workbook, or copy them from
one sheet to another?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Copy printer setup to new sheet in workbook

If you make your new sheet by copying an existing one (i.e. CTRL-drag a
sheet tab into the same workbook window) then you will have an exact
copy and the printer setup parameters will be the same. You could do
this with last month's sheet and then delete all the data on it, or set
up a blank sheet to be used as a template for a new month.

Hope this helps.

Pete

dougforester wrote:
Using Excel 2003. I create a new sheet every month (monthly health calendar).
I can copy the contents of the previous month as a starting point, but I have
to enter the printer setup info from scratch every time - very tedious. Is
there a way I can set the printer parms for the workbook, or copy them from
one sheet to another?


Reply
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
How to merge monthly workbooks into a quarterly workbook?? erinattbt123 Excel Worksheet Functions 6 September 19th 06 10:56 PM
Copy sheet - Break Links to Old Workbook - Retain Formula. Mr Anonymouse Setting up and Configuration of Excel 1 October 15th 05 01:00 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Excel won't copy outside sheet Jack Sons Excel Discussion (Misc queries) 6 May 17th 05 10:05 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM


All times are GMT +1. The time now is 04:57 PM.

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"