#1
|
|||
|
|||
Check before using Application.Dialogs(xlDialogSendMail)
Dear All,
I have succesfully integrated a VBA script which checked several form fields before printing or saving the file to ensure that the form was filled correctly. I've used Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean) and Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) but what would be the right object/script to implement a simple if/then check for the expression Code:
Application.Dialogs(xlDialogSendMail) Many thanks for your help. Best regards Florian |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Control boxes, protection and pop-up dialogs | wolfgrrl | Word | 1 | 05-08-2019 12:49 PM |
Dialogs(wdDialogInsertSymbol).show -- How to keep the dialogue floating? | sanrou | Word VBA | 2 | 01-08-2019 07:56 PM |
Application.Dialogs - Show mail merge 'Select Recipients" dialogs | Cosmo | Word VBA | 0 | 10-08-2013 07:58 AM |
cannot check/uncheck check box but added check box | learn2office | Word | 1 | 11-27-2012 02:02 AM |
There are too many find public folders dialogs open. You must close them in order to | asiatic | Outlook | 1 | 01-08-2011 10:56 AM |