Workbook_open : Putting in message in titlebar (Visual Basic)

  • Thread starter Thread starter Jorgen [DK/2600]
  • Start date Start date
J

Jorgen [DK/2600]

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
 
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!
 
thanks.

- jorgen

kassie said:
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!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximize and minimize a usercontrol within a form in c# 1
Multiple workbook sheet numbers! 4
Change a part of text to Bold in the form's titlebar 2
given InternetExplorer object, how do you get it's text in titlebar? 1
Dialog with no TitleBar: is it possible? 4
Stopping a macro to edit the template then re-saving the macro for use 4
Custom Titlebar Troubles 2
Display COUNT result in Titlebar 4

Back
Top