Press Alt+F11 and in the project explorer on the left of the screen, double
click ThisWorkbook to open the workbook module.

Place something similar to the following code in the Workbook's On Open event.

Private Sub Workbook_Open()

MsgBox "Only enter data in the cells w/tan color."

End Sub
--
Kevin Backmann


"McCloudK" wrote:

I would like a simple text box or message to appear when a spreadsheet is
first opened that will require the user to push OK.

What I actually want is a box to pop up as sson as the spreadsheet is opened
that says "Only enter data in cells that are color coded Tan!" I would like
the message to stay on the screen until the uses clicks an OK button.

How would I accomplish this?

Thanks,

Ken