Fairly Advanced Problem

I want to add a windows style prompt that will apear when a wookbook is opened. It will need to read something along the lines of "Stop Press and then list my special offer" the person that has opened the work book will have to click OK before they can continue to use it... How do I do this?

Private Sub Workbook_Open()
MsgBox "Put your message here"
End Sub

I still can't get this to work. I take it I write this as a macro? Help!

Put it in the ThisWorkbook code module.

[Dave Hawley]

Hi


Right click on the Excel icon (top left next to File) and select "View Code"

My limited Excel knowledge is failing me.
Can you tell me how to do this step by step?
I am good with macro's and have a fairly good working knowledge of the programme but I am being really thick on this occasion.

Done it - Made it work! Thank you.