Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Message box (97)

    Hi
    Is it possible that when you open excel it will say

  2. #2
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Message box (97)

    Hi Buckshot,
    I think this may work.
    Navigate to the Visual Basic Editor <alt + F11>
    Open the Project Explorer window <Ctrl + R>
    Select ThisWorkbook
    Left hand drop down box select Workbook
    Complete the procedure skeleton with the code in red

    Private Sub Workbook_Open()
    <font color=red>If Now() > 1200 Then MsgBox "Good Afternoon, Buckshot" _
    Else MsgBox "Good Morning, Buckshot"</font color=red>
    End Sub

    Close the Visual Basic Editor.
    Save your workbook under an appropriate name then close it.
    Reopen your workbook and "Enable Macros".
    You will be greeted with a message as you required every time the workbook is opened.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Message box (97)

    Hi Buckshot,

    Bandido has given a good epxlanation of how to create a macro that will be executed each time a particular workbook is opened. If you want to be greeted each time Excel is started, create this Workbook_Open macro in your personal macro workbook Personal.xls. See Legare Coleman's <!post=Personal.xls Tutorial,118382>Personal.xls Tutorial<!/post> if you don't know what Personal.xls is or how to use it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •