Combination of "Dialogs" functions faulty?

[Peter Ostermann]

The problem seems to be for everybody easily reproducible:
1. place a button on a sheet
2. the button calls a form containing 2 buttons:
a. preview
code:

me.hide
Application.Dialogs(xlDialogPrintPreview).Show by
me.show
b. mail
code: Application.Dialogs(xlDialogSendMail).Show

test preview: it works
test mail: it works
test preview again: result: ***** frozen *****

So, it really seems to be a Microsoft problem !!

isn't there any MVP maintaining this NG who could give me
a helping hand, any hint for a workaround?
Thanks.

Best Regards
Peter

 

[Jack D.]

The problem seems to be for everybody easily reproducible:
1. place a button on a sheet
2. the button calls a form containing 2 buttons:
a. preview
code:

me.hide
Application.Dialogs(xlDialogPrintPreview).Show by
me.show
b. mail
code: Application.Dialogs(xlDialogSendMail).Show

test preview: it works
test mail: it works
test preview again: result: ***** frozen *****

So, it really seems to be a Microsoft problem !!

isn't there any MVP maintaining this NG who could give me
a helping hand, any hint for a workaround?
Thanks.

Best Regards
Peter

2 suggestions.

1) Try posting in an excel newsgroup. This is for Microsoft Project.

2) Have the button close the other dialog box.


--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++