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
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