EXCEL

What do you mean by "can't" ?

If you click on File, Print, there is a radio button where you can select to print the entire workbook.

Do you receive an error message when you use this option?

If you describe the problem in more detail I might be able to help further.. :-)
Ed

I do not get an error message when trying to print using the entire workbook feature. It just goes out into space. We use NDPS printing and it does not even show as a print job. No other small print job shows up though.

I don't know if your up to the code, but you can make a button and assign vb code to it. Simply go into the visual basic editor, and make a module. The could will be based on the names of the sheets in your workbook.
sheet1.printout
sheet2printout
sheet3.printout

now you can either make a toolbar button and assign this code to the onclick of that button, or you can make a form button and place it somewhere on one of your worksheet, it really doesn't matter. The only thing you have to remember is that, if you want to use this in multiple workbooks, the sheet names and how many of them there are will need to be checked. Now when you are in the code editor, you will see an objects window. It has all of your sheets, forms, modules. You might have renamed a sheet (for example) finances, and another budget. If you look at the objects, those sheets are probably still refered to by excel as sheet1 and sheet2, so check that.

Other than that you are set. I have an faq around here on one of the discussions about user defined fields. It discusses automation excel worksheets. Check it out if you want more tips.
Good luck

Go to pulldown menu.
File, Print Area, Select the area that you want to print click Set Print Area, Adjust it to Print Preview and Scale to Fit.

This question was closed by the author