G
Ginger
Is there a way to set so a message displays at opening of a workbook/worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marcelo
Create a form on the VBA and use the command
Option Explicit
Private Sub Workbook_Open()
NomeDoForm.Show
End Sub
Regards
"Ginger" escreveu:
Option Explicit
Private Sub Workbook_Open()
NomeDoForm.Show
End Sub
Regards
"Ginger" escreveu:
O
Otto Moehrbach
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
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
G
Ginger
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
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