excel printing

[Guest]

is there a script or trick to print odd/even pages in
excel?
word has it!
Thankx in advance!
mdooly

 

[Ron de Bruin]

Try this

http://www.rondebruin.nl/print.htm#odd

 

[mdooly]

Can the macro be loaded into excel directly?
I have never used them, I see how one can be recorded...
and there is the ms vb editor ... should I just copy the
macro into the vb editor and save it accordingly?

Much thanx by the way

mdooly

 

[Ron de Bruin]

Hi mdooly

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "Print_Odd_Even" and press Run

 

[mdooly]

Ron you are a very kind hearted person, I am sorry to
bother you, but one last question. I have built macros in
the past... actually recorded a couple and that is all...
but I have noticed the macro stays glued to the worksheet
that is open or excel appears to load a sheet by default,
when I insert the macro as per your posting.
The question(s):
Can I keep it resident to Excel and call it for just any
sheet?
Or do I need to be prepard to insert it into any new sheet?

if so then I can imagine my best opportunity would be to
use a template...

thank you again you have been a marvelous person!
Respectfully
mdooly

 

[Ron de Bruin]

Hi again

If you want to use the macro in all your workbooks you can copy the macro in your personal.xls.
This is a (normally) hidden workbook that is loaded automatically by Excel.
When you record a macro, you have the option of recording it to your Personal Macro Workbook.
The file, Personal.xls, is stored in your \XLStart directory.

The easiest is to record a dummy macro and choose Personal Macro Workbook.
Excel create the file for you this way.
Then copy the print macro in this file and delete the dummy macro.