PDA

View Full Version : formname.PrintForm disables msgbox



ief
04-16-2008, 02:53 AM
Hi,

I've come across a problem in Excel '97 vba where the following line of code disables message boxes that I've embedded in the code.

formname.PrintForm

When I comment it out, there's no problem. I've tried the same process on a colleague's machine with Excel 2003 and everything works.

Can anyone please tell me if there's a patch that resolves this issue in '97, or if there's a line of code that would enable the message boxes?

Application.DisplayAlerts = True has been tried and failed.


Many thanks

ief

Oorang
04-24-2008, 08:55 PM
Does me.Printform cause the same issue? What actually happens when the msgbox tried to execute? Can you reproduce the error on other machines with 97?

ief
04-25-2008, 12:12 AM
Hi Aaron,

Thanks for your response. me.Printform does cause the same issue. Tried this on a number of machines with 97, and had the same problem. It's beginning to look like an Excel glitch....

The code continues to run following the print. The first message box flashes up and closes down in a instant without user intervention, and no further message boxes appear until Excel is closed and re-opened.


Thanks again


ief

Bob Phillips
04-25-2008, 12:28 AM
Can you post the code that does this?