[mso] Re: Print macro
- From: "Ratliff, Roberta" <RBRATLIFF@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 29 Nov 2006 13:08:59 -0500
Linda and/or Diane,
I work for a private university that will be upgrading all computers on
campus to Office 2007 in the near future. Do you, by chance, have any
links to Office 2007 ebooks where we could do some teaching/training
purposes for our clients? If so, is there a charge for the ebooks and
what would the cost be?
Roberta Ratliff
Client Services Coordinator
Taylor University - Upland
765-998-4042
=20
"I can do everything through Him who gives me strength."
~Phillipians 4:13 ~
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Linda F. Johnson
Sent: Wednesday, November 29, 2006 8:31 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Print macro
Have you tried just turning on the macro recorder and doing the steps
you
normally do? That will create a macro to complete the steps. Then just
go
to View>Toolbars>Forms, when the Forms Toolbar appears, click on the
Button
button, then click on your spreadsheet .... When you release you mouse,
a
box comes up where you can choose your macro to assign to this button.
Then
you can change the text on the button to anything you want.
Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf
Of Jens Outzen
Sent: Wednesday, November 29, 2006 7:15 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Print macro
I have just discovered that my company has not included advanced Excel=20
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=20
have made more sense printing straight from the excel files rather than=20
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=20
available spreadsheets I have had to create a number of sheets covering=20
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=20
available (the sheets are hidden from view so people can't mistake one=20
from the other). This works - but only for me as I am the only one who=20
knows exactly what to do.
In order to minimize training I would like to install a "print" button
on=20
the "working" sheet. The function would be to print the hidden sheet=20
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
*************************************************************
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
*************************************************************
*************************************************************
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: