Del,

You need to hide the application, (Application.Visible = False), display the
message, and then show the application (Application.Visible = True)

This will do the trick. Put this in your workbook module:

Private Sub Workbook_Open()
With Application
.Visible = False
MsgBox "Test", vbCritical, "This is a test"
.Visible = True
End With
End Sub


"Del" wrote:

I have a small workbook in Excel 2007 and I have some macros for it. I want
to be able to create a pop-up message that says "Reminder: in order for
things to work right, please enable macros..."

I can do this AFTER the workbook is open, but I need to do it prior to it
opening. As in, I double-click to open the file, and then I get the message
prior to the workbook opening completely.

How do I do this?? Thanks!