OK. The next thing to try is renaming your excel.xlb. Close Excel and do a
search for it on your PC and rename it to excel.xlbold (or similar). I know
that this has caused printing problems in the past with some users. Excel
will recreate an xlb file when you restart the program.

Andy.

"pywhacket" wrote in message
...
Yes, I did say no.

"Andy" wrote:

Did you say 'No' to the 'Enable Macros?' question when you opened the
sheet?

Andy.

"pywhacket" wrote in message
...
It still locks up when the macro security is set to high.
"Andy" wrote:

OK. I've never had a sheet not print because there were too many
formulas
on
it, so I would say that one of your macros is to blame.
Try setting your macro security to High, then opening the sheet and
printing. Does that change anything?

Andy.
"pywhacket" wrote in message
...
The simpler sheets do print.

"Andy" wrote:

Michele

What happens if you try to print another, simpler sheet? This
should
determine whether the macros may be affecting the printing.

Andy.

"pywhacket" wrote in message
...
Andy,

My print driver is up-to-date. I have also gotten other people to
try
it -
same problem for all.

Michele

"Andy" wrote:

Hi pywhacket

The first thing to check is that your printer driver is
up-to-date.
I
believe that the Print Preview is 'managed' by the printer
driver,
as
the
print is, of course!

Andy.

"pywhacket" wrote in
message
...
Hello, I have a workbook that contains several macros and many
formulas.
It
works beautifully until I try to print or do a print preview.
Then
it
locks
up excel and I have to restart. Any ideas about what is
causing
this?

Thanks!