Pop up window when opening 2010

[rob little]

OK, so have looked on this forum for an answer to this question;
I would like to have a pop up window come up when a excel file is opened stating the user must save the workbook as another name before altering the data. I have seen alot of suggestions using VB and Mcros, but I can get t box to show up but not pop up at opening. Specifically I would like it to look like a warning box. Can anyone help me with this?
Thanks!

[Mumps1]

If all you want is a warning message to pop up, put the following code into the code module for 'ThisWorkbook' (not into a regular module). Next save the file, close it and re-open it. When you re-open it, the message will pop up.

Please Login or Register  to view this content.

[rob little]

Thanks! Can I add a clip art logo to the box?

[Mumps1]

Unfortunately, you can't add a graphic to a message box. You would have to design a user form with the message and the graphic and have the Workbook_Open event display the form when you open the file.