Hi Sheila,
You need to create a new macro (ALT+F11) and add a Workbook_Opened event (on
the left side click on ThisWorkbook; a new window will open and in left
dropdown select Workbook and Workbook_Opened will be added). Next, you just
add this line (between Private Sub Workbook_Opened() and End Sub):
MsgBox "Complete section two before entering section one"
Message box will be displayed when document is opened.
--
Best regards,
Peter JauĊĦovec
http://blog.jausovec.net
http://office.jausovec.net
"Sheila" je napisal:
I would like to display a message "Complete section two before entering
section one" when an excel file is opened.
Any help would be appreciated.