| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workbook_open : Putting in message in titlebar (Visual Basic)
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Workbook_open : Putting in message in titlebar (Visual Basic)
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Workbook_open : Putting in message in titlebar (Visual Basic)
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Workbook_open : Putting in message in titlebar (Visual Basic)
thanks.
- jorgen "kassie" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Visual Basic error on Launch | Setting up and Configuration of Excel | |||
| microsoft visual basic compile error can't find library | Setting up and Configuration of Excel | |||
| Loading a linked spreadsheet, Microsoft Visual Basic, error while. | Excel Discussion (Misc queries) | |||
| I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
| Visual Basic Error Message | Excel Discussion (Misc queries) | |||
Linear Mode
