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

If printing (or print previewing) causes crashes, I'd go to the printer
manufacturer's site and look for updated printer drivers.



Brotherwarren wrote:

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

--

Dave Peterson

On 17 Jan, 18:04, Dave Peterson wrote:
If printing (or print previewing) causes crashes, I'd go to the printer
manufacturer's site and look for updated printer drivers.





Brotherwarren wrote:

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

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks, I've tried up[dating the drivers with no luck.

Print preview doesn't cause problems?

I've received the following info in an error report that has started
appearing when I try to print on some of the machines in our building:

AppName: excel.exe AppVer: 11.0.5612.0 AppStamp:3f39ff9d
ModName: unknown ModVer: 0.0.0.0 ModStamp:00000000
fDebug: 0 Offset: 7470b439

Does this help anyone identify the problem?

Thanks again for any advice offered.

Tony

Not me.

If there's some unique string in that report, maybe you can google for it.

Brotherwarren wrote:

<<snipped

Thanks, I've tried up[dating the drivers with no luck.

Print preview doesn't cause problems?

I've received the following info in an error report that has started
appearing when I try to print on some of the machines in our building:

AppName: excel.exe AppVer: 11.0.5612.0 AppStamp:3f39ff9d
ModName: unknown ModVer: 0.0.0.0 ModStamp:00000000
fDebug: 0 Offset: 7470b439

Does this help anyone identify the problem?

Thanks again for any advice offered.

Tony

--

Dave Peterson