Hi

Open the VB editor (Alt F11 or similar).
Menu Insert Module.
Paste this into the module:

Sub Auto_open()
MsgBox "enter name in cell A6", vbOKOnly, _
"Any assistance would be appreciated"
Range("A6").Select
End Sub

Save, close, reopen.

HTH. Best wishes Harald

"webster" skrev i melding
...
I want to have a dialog box pop up when I open an excel workbook. I just
want it to say something like 'enter name in cell A6" and then have an
"OK"
button that closes the pop up.

Any assistance would be appreciated