VALIDATION IN EXCEL

Is there a way to set so a message displays at opening of a workbook/worksheet?

Create a form on the VBA and use the command


Option Explicit

Private Sub Workbook_Open()

NomeDoForm.Show

End Sub

Regards


"Ginger" escreveu:

> Is there a way to set so a message displays at opening of a workbook/worksheet?

Ginger
There are several ways to display a message at opening. Marcelo gave
you one. Another is to display a message box (MsgBox). The message box can
be simply informative and have an OK button, or it can ask a question (and
have Yes and No buttons) if appropriate, depending on your purpose. Post
back and tell us what you want to do. HTH Otto
"Ginger" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to set so a message displays at opening of a
> workbook/worksheet?

Thank you for your responses, what I would like to have is a message box
which pops-up when you open a workbook/worksheet. I would like this to only
pop-up every two weeks, the purpose is to remind employees of a specific event

"Otto Moehrbach" wrote:

> Ginger
> There are several ways to display a message at opening. Marcelo gave
> you one. Another is to display a message box (MsgBox). The message box can
> be simply informative and have an OK button, or it can ask a question (and
> have Yes and No buttons) if appropriate, depending on your purpose. Post
> back and tell us what you want to do. HTH Otto
> "Ginger" <[email protected]> wrote in message
> news:[email protected]...
> > Is there a way to set so a message displays at opening of a
> > workbook/worksheet?
>
>
>