<div>
One way is with a simple Msgbox. In Workbook_Open:<br />
<br />

<pre><code id="code-20-42564075-1">Private Sub Workbook_Open()
MsgBox &quot;...is not complete yet&quot;, vbInformation, &quot;Project Status&quot;
End Sub</code></pre>
</div>


29099562.xlsm

<div>
Thanks Martin - worked as expected.
</div>


<div>
I corrected the typo:) and you’re welcome and I’m glad I was able to help.<br />
<br />
If you expand the “Full Biography” section of <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you’ll find links to some articles I’ve written that may interest you.<br />
<br />
Marty - Microsoft MVP 2009 to 2017<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Most Valuable Expert (MVE) 2015, 2017<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Top Expert Visual Basic Classic 2012 to 2017<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Top Expert VBA (current)
</div>


<div>
Well there older than dirt,<br />
Thanks for the correction and links. Have a safe summer
</div>


<div>
<div class="content wysiwyg-content">
Folks,<br />
I am have started a workbook that still has some work to do. I will be sending this to show some of my skills. What I need is a dialog box that notifies the user what part of the workbook is still a work-in-progress. How is that done?
</div>
</div>


Folks,
I am have started a workbook that still has some work to do. I will be sending this to show some of my skills. What I need is a dialog box that notifies the user what part of the workbook is still a work-in-progress. How is that done?

One way is with a simple Msgbox. In Workbook_Open:

(CODE)

I corrected the typo:) and you’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile (https://www.experts-exchange.com/M_258447.html) you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
              Experts Exchange Top Expert VBA (current)

Well there older than dirt,
Thanks for the correction and links. Have a safe summer

Dialog box when Excel opens

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.