[mso] Print macro

  • From: Jens Outzen <Jens.N.Outzen@xxxxxxxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Wed, 29 Nov 2006 12:14:56 +0000

I have just discovered that my company has not included advanced Excel 
software help from our outsourced IT company.
Shame!
I am in a bid of a pickle. We have a preprinted card (yes, i know would 
have made more sense printing straight from the excel files rather than 
unto preprints) which need to get populated. This was originally created 
in Word and not Excel. in order to get this to work from some other 
available spreadsheets I have had to create a number of sheets covering 
each section. Problem is then printing. In order to avoid overprinting I 
have had to create a mirror sheet with only the relevant print data 
available (the sheets are hidden from view so people can't mistake one 
from the other). This works - but only for me as I am the only one who 
knows exactly what to do.
 In order to minimize training I would like to install a "print" button on 
the "working" sheet. The function would be to print the hidden sheet 
instead of the one being worked upon.
1. Can anyone please help with such a macro, please?
2. Is there anywhere on-line I can get training in macros?
3. Is there a better alternative?
Thanks in advance.



Jens N. Outzen
Admin Assistant
Hackney Depot
0208 533 9757 - for direct dial 9 then 220
07921 942 559 (Mob)

**********************************************************************
This message is confidential. It may not be disclosed to, or used by, 
anyone other than the addressee. If you receive this message in 
error, please advise us immediately.

Internet email is not necessarily secure. First does not accept
responsibility for changes to any email which occur after the email
has been sent. Attachments to this email could contain software
viruses which could damage your system. First have checked the
attachments for viruses before sending, but you should virus-check
them before opening.

For more information on our range of services or to book your tickets
online, please visit:- http://www.firstgroup.com
**********************************************************************



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: