Results 1 to 7 of 7

Welcome message in Excel

This is a discussion on Welcome message in Excel within the Excel Questions forums, part of the Question Forums category; Hi can anyone help? Can i write code to pop up with a message box when the file is opened ...

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Location
    Aberdeenshire, Scotland
    Posts
    65

    Default Welcome message in Excel

    Hi can anyone help?

    Can i write code to pop up with a message box when the file is opened and if so, how?

    Thanks

    Paul

  2. #2
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,501

    Default Re: Welcome message in Excel

    Right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

    Code:
    Private Sub Workbook_Open()
    MsgBox "Hello and welcome!", vbInformation
    End Sub
    Save the workbook, close it and re-open it to see the effect.
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    Board Regular baitmaster's Avatar
    Join Date
    Mar 2009
    Location
    bristol, england
    Posts
    1,123

    Default Re: Welcome message in Excel

    macro named auto_open, or stored within ThisWorkBook module, on OPEN

    either a message box (msgbox), or a user form, which can contain images, allsorts. I usually select a front page too, and check protection is applied correctly, that sort of thing

  4. #4
    Board Regular
    Join Date
    Mar 2009
    Location
    Aberdeenshire, Scotland
    Posts
    65

    Default Re: Welcome message in Excel

    Thanks Chaps

  5. #5
    Board Regular
    Join Date
    Mar 2009
    Posts
    113

    Default Re: Welcome message in Excel

    baitmaster
    could you please explain how to use a user form at start up and not a message box

    thanks
    don

  6. #6
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: Welcome message in Excel

    Code:
    Private Sub Workbook_Open()
    UserForm1.Show
    End Sub
    lenze
    If you have to tell your boss you're good with Excel, you're NOT!!
    All I know about Excel I owe to my ignorance!
    Scotch: Because you don't solve great Excel problems over white wine

  7. #7
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Glasgow, Scotland
    Posts
    6,292

    Default Re: Welcome message in Excel

    Splashscreen seems to be popular these days too, but I think it's based on Userforms

    http://www.ozgrid.com/Excel/excel-splash-screen.htm

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com