"Tom Ogilvy" wrote in message
...
When you set a print area, excel accesses the default print driver to do
so.
Perhaps your default print driver is corrupt or try setting a different
print driver as the default.

--
Regards,
Tom Ogilvy


"sacrum" wrote in message
...
Hi all,

I have just migrated my workbook from my standalone laptop to a work
networked pc - My pc uses excel 2003 pro and work pc excel 2003. When I
execute the copied workbook on the n/w pc it opens, I enable macro's no
problem. When I try to do things such as set a print area excel hangs -
taskmgr shows excel as not responding! Everthing is fine on my laptop so
not sure what the issue could be. The VB used is self contained as in it
does not create temporary files or require external data.

Advice welcomed....tia



you're a clever bunch...excel is installed locally on the nw pc not on a app
server. There were problems with the nw printers today and virus shield is
running. Thanks for the pointers, I'll look into both in the morning..