Sheets with VBA controls won't print.

[Stephen Sharpe]

I am using Excel 2000 to create simple forms which include some controls on
the sheet.

Depending on the printer, Excel freezes, or returns an error message when I
try to print.

Is there any way to fix this?

Stephen

 

[NickHK]

Stephen,
What is the error ?

NickHK

 

[Stephen]

Thanks NickHK

The error with Epson 880's, is a Windows message box "This program has
performed an illegal operation and will be shut down. If the problem
persists, contact the program vedor"

The message box has an option to "Close" which is mostly unresponsive,
"Debug" and "Details".

Details gives the following: EXCEL caused an invalid page fault in
module <unknown> at 00de:0066006f. This is followed by a list of the
register values.

Initialy only a couple of users in my company with Epson 880 printers
were affected and I did a work around that allowed them to get by with
these printers. Later however, I added some more embellishments to the
form which has now caused more widspread problems. Some machines lock as
soon as you click Print Preview or try to print, others stop displaying
data from the Excel cells and print a form with much of the data
missing.

I initialy refered the problem to Epson's on-line technical help. After
trying a few different driver versions they gave up.

I have also upgraded Office 2000 to SP3 but with no luck.

Any Sugestions?

StephenS