Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2023, 05:31 AM
holzhauerf holzhauerf is offline Check before using Application.Dialogs(xlDialogSendMail) Windows 10 Check before using Application.Dialogs(xlDialogSendMail) Office 2021
Novice
Check before using Application.Dialogs(xlDialogSendMail)
 
Join Date: May 2023
Posts: 1
holzhauerf is on a distinguished road
Default 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)
to check before printing



and

Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
to check before saving

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Check before using Application.Dialogs(xlDialogSendMail) 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft