Hi folks,

I have an unusual problem that I hope someone may be able to shed some
light on.

I have been using a macro to print a number of pages of information
stored in a spreadsheet.

The macro changes a scroll bar's value, which in turn updates some
info from a master data page to a 'form' (actually a well disquised
worksheet) that contains textboxes, graphs, and graphics.

I have made no changes to the worksheet other than entering new data,
i.e. the macro hasn't been changed at all. (also a backup of an old
version that used to work and has not been altered at all now displays
the same error)

For no apparent reason the macro now crashes excel, without any error
message or other sign of what is going on. Depending on which printer
I send to, excel either crashed instantly, ( an HP B&W cheap laserjet
attached locally), after two or three pages (an HP colour laserjet,
networked) or prints fine, without crashing (a battered and bruised
old inkjet.

Has anyone had problems like this in the past? Can anyone suggest a
route to check?

Many thanks for any help that you can give,


I'm rapidly running out of hair to pull !?!

Tony