Disable MsgBox permanently after "OK"

[cizzett]

OK excel guru's, I have a MsgBox that runs when I open the workbook template telling the user to paste previous days data in the prev day worksheet before proceeding.

What I want is to permanently disable this MsgBox after selecting OK so once the user has saved the file under the new name it no longer pop's up this message.

In other words, I only want the message to run when the template is used to create a new workbook and after the user clicks OK it no longer shows the MsgBox.

Any Idea's?

Here's the MsgBox I'm using

Private Sub Workbook_Open()

MsgBox "Please paste previous days data into the Prev Day sheet before proceeding", vbOKOnly + vbExclamation, "Before Proceeding"


End Sub

 

[cizzett]

Correct, they must save it as a new file which is why I don't worry about clearing it. But once they create the new file to be stored for that day it wont continue to pop up the box when they re-open.

The template is used to create a new file daily, personally id keep a running file but this is what is wanted, a new file for each day.

 

[cizzett]

this is a template, as in .xltm, so when they open it it automatically changes to a workbook which they have to save as a new name and the way they use it is they use a new workbook daily saved as that days date for future reference. Personally I would keep a singular running file but not my call.

 

[Joe4]

I got it. Make sense now.
Glad it all works out for you!

 

[cizzett]

I appreciate the help, truly.

 

[Joe4]

You are welcome.
Sorry for the confusion, I don't work much with templates.