VBA Procedure (or Macro) to Stop Outlook from Closing?

Status
Not open for further replies.
N

ND Pard

I am new to using Outlook, but have written many Access and Excel VBA

procedures.

Often, I unintenionally click the "X" close button in the upper right corner

of the application.

Outlook provides a dialog box that states, "Are you sure you want to

permanently delete all the items and subfolders in the "Deleted Items" folder?

I do NOT want to even close Outlook, much less delete items!

I would like a dialog box that allows me to cancel the closure of Outlook.

What would the VBA macro look like to cancel my unintended closure of Outlook?

Please cc your response to: btescher@nd.gov

Your response will be appreciated.
 
You could use the Outlook object model to cancel the click on File/Close,

but it doesn't offer anything cancel a click on the "X" button. Instead,

you'd have to use a lot of Win32 API calls and hook into the sent Windows

messages.

There's already a tool available for that, please see 'OLKeeper' here:

http://www.vboffice.net/product.html?lang=en

Best regards

Michael Bauer

Am Thu, 10 Dec 2009 09:25:01 -0800 schrieb ND Pard:


> I am new to using Outlook, but have written many Access and Excel VBA
> procedures.

> Often, I unintenionally click the "X" close button in the upper right


corner
> of the application.

> Outlook provides a dialog box that states, "Are you sure you want to
> permanently delete all the items and subfolders in the "Deleted Items"


folder?

> I do NOT want to even close Outlook, much less delete items!

> I would like a dialog box that allows me to cancel the closure of Outlook.

> What would the VBA macro look like to cancel my unintended closure of


Outlook?

> Please cc your response to: btescher@nd.gov

> Your response will be appreciated.
 
Try OutLock

http://www.brothersoft.com/outlock-for-outlook-28886.html

ND Pard wrote:

VBA Procedure (or Macro) to Stop Outlook from Closing?

10-Dec-09

I am new to using Outlook, but have written many Access and Excel VBA

procedures.

Often, I unintenionally click the "X" close button in the upper right corner

of the application.

Outlook provides a dialog box that states, "Are you sure you want to

permanently delete all the items and subfolders in the "Deleted Items" folder?

I do NOT want to even close Outlook, much less delete items!

I would like a dialog box that allows me to cancel the closure of Outlook.

What would the VBA macro look like to cancel my unintended closure of Outlook?

Please cc your response to: btescher@nd.gov

Your response will be appreciated.

Previous Posts In This Thread:

SQLITE 3 for Compact Framework Available

http://www.eggheadcafe.com/tutorial...9-2d79749c55b5/sqlite-3-for-compact-fram.aspx
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
H using VBA to edit subject line Outlook VBA and Custom Forms 0
G Get current open draft message body from VBA Outlook VBA and Custom Forms 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
V VBA Categories unrelated to visible calendar and Visual appointment Categories Outlook VBA and Custom Forms 2
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 2
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
R Outlook 2019 VBA to List Meetings in Rooms Outlook VBA and Custom Forms 0
geoffnoakes Counting and/or listing fired reminders via VBA Using Outlook 1
O VBA - Regex - remove double line spacing Outlook VBA and Custom Forms 1
D.Moore Strange VBA error Outlook VBA and Custom Forms 4
B Modify VBA to create a RULE to block multiple messages Outlook VBA and Custom Forms 0
D Outlook 2021 Using vba code to delete all my spamfolders not only the default one. Outlook VBA and Custom Forms 0
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
D VBA - unable to set rule condition 'on this computer only' Outlook VBA and Custom Forms 5
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1
W Can vba(for outlook) do these 2 things or not? Outlook VBA and Custom Forms 2
MattC Changing the font of an email with VBA Outlook VBA and Custom Forms 1
P MailItem.To Property with VBA not work Outlook VBA and Custom Forms 2
P Tweak vba so it can target another mailbox Outlook VBA and Custom Forms 1
A Outlook 2010 VBA fails to launch Outlook VBA and Custom Forms 2
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
TedSch Small vba to kill political email Outlook VBA and Custom Forms 3
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
Z VBA Forward vs manual forward Outlook VBA and Custom Forms 2
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Any way to force sort by/group by on search results with VBA? Outlook VBA and Custom Forms 1
E Default shape via VBA Outlook VBA and Custom Forms 4
A Change settings Send/receive VBA Outlook VBA and Custom Forms 0
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
D VBA code to select a signature from the signatures list Outlook VBA and Custom Forms 3
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
David McKay VBA to manually forward using odd options Outlook VBA and Custom Forms 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S vba outlook search string with special characters Outlook VBA and Custom Forms 1
S VBA search string with special characters Outlook VBA and Custom Forms 1
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
DDB VBA to Auto Insert Date and Time in the signature Outlook VBA and Custom Forms 2
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11

Similar threads

Back
Top