Thanks Celia but that isn't exactly what I want. I want a message box to display when a new template is opened. The message box just gives them some information about the template and they only have to click ok, then the message box will go away.
Donna
Put the following in the ThisWorkbook module :-
Private Sub Workbook_Open()
MsgBox "Put your message here"
End Sub
Celia
Donna
I'm not sure this is what you want, but the following will open a new workbook and display the "Save As" dialog box :-
Workbooks.Add
Application.Dialogs(xlDialogSaveAs).Show
Celia
Thanks Celia. That was the answer to my question. How long have you been doing this?
Donna
I started trying to learn VBA about 6 months ago.
Celia