Toolbar Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I may be asking the impossible, but you all have led me to
believe that nothing is impossible :). I'm trying to add
a command to my toolbar in Excel that will let me print
envelopes (similar to the envelopes and mailings command
in Word), is this possible?
 
Two issues:
1) Formatting of Excel sheets for ANY kind of printing: Easily done via
macros which can be connected to toolbar buttons. Perhaps the easiest way to
learn this is to record the things you do manually, and then fine-tune the
resulting VBA code, maybe with a VBA book handy (or the help file).

2) Adjusting printer properties: I've found there's a limited number of
things you can do via script control. But, I recently read a great tip.
Install a 2nd "copy" of your printer. Rename it something like HP-Envelopes,
to differentiate it from your normal settings. Adjust that "instance" of the
printer (through Settings, Printers) in whatever may makes it work best for
envelopes. Then, all the Excel macro needs to do is select that printer by
name.
 
Thank you very much Doug, I'll give it a try!
-----Original Message-----
Two issues:
1) Formatting of Excel sheets for ANY kind of printing: Easily done via
macros which can be connected to toolbar buttons. Perhaps the easiest way to
learn this is to record the things you do manually, and then fine-tune the
resulting VBA code, maybe with a VBA book handy (or the help file).

2) Adjusting printer properties: I've found there's a limited number of
things you can do via script control. But, I recently read a great tip.
Install a 2nd "copy" of your printer. Rename it something like HP-Envelopes,
to differentiate it from your normal settings. Adjust that "instance" of the
printer (through Settings, Printers) in whatever may makes it work best for
envelopes. Then, all the Excel macro needs to do is select that printer by
name.





.
Click to expand...
 
The main issue you may run into with the script is that it'll name the sheet
you were working on when you recorded it. That means it'll only work on that
specific sheet. However, there's a way to edit the script to work on
WHATEVER is the current sheet. It's been ages since I played with a script,
so someone else will have to chime in here and tell you how to fix that
detail. My hunch would be to search the help system for the word "current",
since the trick may be as simple as calling it "Current_Sheet" or some such
thing.
 
You can use Activesheet to refer to the current sheet.
-----Original Message-----
The main issue you may run into with the script is that it'll name the sheet
you were working on when you recorded it. That means it'll only work on that
specific sheet. However, there's a way to edit the script to work on
WHATEVER is the current sheet. It's been ages since I played with a script,
so someone else will have to chime in here and tell you how to fix that
detail. My hunch would be to search the help system for the word "current",
since the trick may be as simple as calling
Click to expand...
it "Current_Sheet" or some such
 
Thanks again, I'm on my way!
-----Original Message-----
The main issue you may run into with the script is that it'll name the sheet
you were working on when you recorded it. That means it'll only work on that
specific sheet. However, there's a way to edit the script to work on
WHATEVER is the current sheet. It's been ages since I played with a script,
so someone else will have to chime in here and tell you how to fix that
detail. My hunch would be to search the help system for the word "current",
since the trick may be as simple as calling
Click to expand...
it "Current_Sheet" or some such
 
Back
Top