software

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
Must it be the title bar, or will a message box also do?

quot;Jorgen [DK/2600]quot; wrote:

gt; Hi,
gt;
gt; I can't find the syntax for putting in a small message in the titlebar when
gt; opening the workbook
gt;
gt; Any one ? 8-)
gt;
gt; regards
gt; jorgen
gt;
gt;
gt;

both is fine ! 8-)

- jorgen

quot;kassiequot; gt; wrote in message
...
gt; Must it be the title bar, or will a message box also do?
gt;
gt; quot;Jorgen [DK/2600]quot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; I can't find the syntax for putting in a small message in the titlebar
gt;gt; when
gt;gt; opening the workbook
gt;gt;
gt;gt; Any one ? 8-)
gt;gt;
gt;gt; regards
gt;gt; jorgen
gt;gt;
gt;gt;
gt;gt;
Hi

Put this in your This Workbook code
Private Sub Workbook_Open()
'MsgBox (quot;Good Day, your favourite spreadsheet is now openquot;)
CreateObject(quot;WScript.Shellquot;).Popup quot; Good day, your favourite
spreadsheet is now openquot;, 3, quot;Welcome back!quot;
End Sub

Obviously, you can replace the posted text with whatever you like!
quot;Jorgen [DK/2600]quot; wrote:

gt; both is fine ! 8-)
gt;
gt; - jorgen
gt;
gt; quot;kassiequot; gt; wrote in message
gt; ...
gt; gt; Must it be the title bar, or will a message box also do?
gt; gt;
gt; gt; quot;Jorgen [DK/2600]quot; wrote:
gt; gt;
gt; gt;gt; Hi,
gt; gt;gt;
gt; gt;gt; I can't find the syntax for putting in a small message in the titlebar
gt; gt;gt; when
gt; gt;gt; opening the workbook
gt; gt;gt;
gt; gt;gt; Any one ? 8-)
gt; gt;gt;
gt; gt;gt; regards
gt; gt;gt; jorgen
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

thanks.

- jorgen

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