View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie
 
Posts: n/a
Default 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