Workbook_open : Putting in message in titlebar (Visual Basic)
Hi
Put this in your This Workbook code
Private Sub Workbook_Open()
'MsgBox ("Good Day, your favourite spreadsheet is now open")
CreateObject("WScript.Shell").Popup " Good day, your favourite
spreadsheet is now open", 3, "Welcome back!"
End Sub
Obviously, you can replace the posted text with whatever you like!
"Jorgen [DK/2600]" wrote:
both is fine ! 8-)
- jorgen
"kassie" wrote in message
...
Must it be the title bar, or will a message box also do?
"Jorgen [DK/2600]" wrote:
Hi,
I can't find the syntax for putting in a small message in the titlebar
when
opening the workbook
Any one ? 8-)
regards
jorgen
|