Why Why print error on macro

johny

Board Regular
Joined
Jul 15, 2002
Messages
69
I completed a project and as its complete
I paste it into other computers and the
print button Performs and Illegal error
to shut down on 7 sheets. ONe of the sheets
print fine no problem but when on certain
sheets it wants to shut down WHHY know. Any
one have this before.
So I bring it to another computer and the same thing happens. THe only computer it works On is my HOme computer. Please help John
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
On the other PC open the application, then from the toolbar select:

File-Page Setup...
then press the: Print... Button and select a printer.

Then try to print, it should work?

You may have set Excel to save printer settings, so when you go to a new PC it looks for the same printer as you have at home.
 

johny

Board Regular
Joined
Jul 15, 2002
Messages
69
Thanks Joe
I will try that when Im back at work

For now I tried adding a new sheet
and pasting the info.and transfering
all vba codes. this has printing
acting normal again. JOHn
 

Forum statistics

Threads
1,144,278
Messages
5,723,465
Members
422,498
Latest member
KAT112014

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top