HELP: Forcing Excel to print Entire Workbook

  • Thread starter Thread starter RJones
  • Start date Start date
R

RJones

I have a small problem that I hope someone may be able to assist me with.

I am trying to force excel to automatically print an entire workbook, e.g.
if it contains many worksheets I want to automatically print everything.

Now I have tried using a macro that selects File--> Print--> Entire Workbook
and have saved this as a Personal Workbook Macro and it works fine for all
new workbooks, however I would like this to work for all workbooks
regardless who they belong to e.g. I would like all workbooks to inherit the
Personal Workbook Macro.

Can this be done, perhaps using VBA?

Any help would be welcome!

PS: I am running Office 2000

rj
 
The macro resides in the Personal.xls file. The Personal.xls file will open
(hidden) automatically whenever Excel opens. As such, any macro in
Personal.xls is available to any open Excel file.
What is happening when the macro doesn't work for you? What are you
doing to execute the macro? Exactly what? Do you get any error messages?
What error messages? HTH Otto
 
Otto Moehrbach said:
The macro resides in the Personal.xls file. The Personal.xls file will open
(hidden) automatically whenever Excel opens. As such, any macro in
Personal.xls is available to any open Excel file.
What is happening when the macro doesn't work for you? What are you
doing to execute the macro? Exactly what? Do you get any error messages?
What error messages? HTH Otto
Click to expand...

Hi thanks for your reply,

OK, When I create a new workbook (Book1) and enter some data into lets say
A1 in Sheet 1, Sheet2 and Sheet 3 and then click on the print icon, all 3
sheets (Entire Workbook) prints as required.

However, if another workbook containing many worksheets is opened and I
click on print, it only prints out Sheet 1.

There are no error messages, and on inspection, the personal workbook macro
is running (Unhide etc.,) and the macro is there.

Have I missed the plot somewhere?

rj
 
I would venture a guess that on the first workbook you have your
Personal.xls print macro assigned to the print icon. Therefore you get
what that macro gives you. In the other workbooks, that same print icon is
the Excel default print icon and you get the default response which is to
print that one sheet.
You will have to assign that same print macro to some icon in every file
or run the macro by Tools - Macro - Macros and find that macro and run it.
HTH Otto
 
Back
Top