Why Why print error on macro

[johny]

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

 

[Joe Was]

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]

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