<div>
I was wondering, when you make changes in any workbook and if you tries to close that workbook, there is default prompt for saving, do you still need above custom msg box?
</div>


I was wondering, when you make changes in any workbook and if you tries to close that workbook, there is default prompt for saving, do you still need above custom msg box?

<div>
Hi Shums,<br />
<br />
Firstly I don't need any msg box for other files but thanks for asking.<br />
<br />
Secondly, As I am not so familiar with VBA can you guide me step by step to copy the above code.<br />
thanks<br />
Ian
</div>


Hi Shums,

Firstly I don't need any msg box for other files but thanks for asking.

Secondly, As I am not so familiar with VBA can you guide me step by step to copy the above code.
thanks
Ian

<div>
If I select 'yes' I would like to save and exit. Can that be done ?
</div>


If I select 'yes' I would like to save and exit. Can that be done ?

<div>
As per your initial request you did asked for Message Box: 
<blockquote>
I would like a message box saying &quot;Have you logged off?&quot;
</blockquote>
:)<br />
<br />
If you are working on one workbook for API Program, then make sure your workbook is saved as .xlsm.<br />
<br />
Press Alt+F11 to open visual basic, in project window you will see ThisWorkbook, double click and paste above code.<br />
<br />
If you select yes it will be saved, but if its not with xlsm extension, it will not save.
</div>


As per your initial request you did asked for Message Box:

> I would like a message box saying "Have you logged off?"

:)

If you are working on one workbook for API Program, then make sure your workbook is saved as .xlsm.

Press Alt+F11 to open visual basic, in project window you will see ThisWorkbook, double click and paste above code.

If you select yes it will be saved, but if its not with xlsm extension, it will not save.

<div>
Oh sorry, I meant I have only one workbook that needs the message box
</div>


Oh sorry, I meant I have only one workbook that needs the message box

<div>
Alt F11 only brings up 'immediate window'
</div>


Alt F11 only brings up 'immediate window'

<div>
Click on View/Project Explorer, you will see below window:<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/05_w22/1165376/ThisWorkbook.JPG" target="_blank" title="This Workbook (22 KB)"><img alt="This Workbook" class="file-block lazyload" style="max-width: 318px;" data-src="https://filedb.experts-exchange.com/incoming/2017/05_w22/1165376/ThisWorkbook.JPG" /></a>
</div>


Click on View/Project Explorer, you will see below window:
This Workbookhttps://filedb.experts-exchange.com/incoming/2017/05_w22/1165376/ThisWorkbook.JPG

ThisWorkbook.JPG

<div>
Yes working fine Shums and thanks again for a quick and professional outcome<br />
Ian
</div>


Yes working fine Shums and thanks again for a quick and professional outcome
Ian

<div>
You're always welcome Ian! :)
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have lost an Excel file several times for not disconnecting an API program.<br />
Therefore I would like a message box saying &quot;Have you logged off?&quot; that appears when I try to close the Excel workbook. This will act as a reminder and save me from hours of file reconstruction.<br />
Many thanks<br />
Ian
</div>
</div>


Hi,
I have lost an Excel file several times for not disconnecting an API program.
Therefore I would like a message box saying "Have you logged off?" that appears when I try to close the Excel workbook. This will act as a reminder and save me from hours of file reconstruction.
Many thanks
Ian

message box

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.