Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel question

  • 02-05-2006 07:11PM
    #1
    dannyd20
    Registered Users, Registered Users 2 Posts: 345 ✭✭


    ok so I've created a spiffy excel file which is really neat and easy to use, cells are locked and protected so the user can only type where they are supposed to, etc.

    I would like to add pop-up instructions so that when a user opens the file they get a quick message making sure they know what to do. Anyone know how to add a message which would pop up on opening the file ?

    Thanks


Comments

  • #2
    calex71
    Closed Accounts Posts: 13,126 ✭✭✭✭calex71


    not sure how to do what you are asking but if you right click on a cell you need the user to add data to and select add comment you can add instrustions on how that cell is to be filled in there, when you click on that cell , the comment will pop up telling the user what to do.


  • #3
    dannyd20
    Registered Users, Registered Users 2 Posts: 345 ✭✭dannyd20


    calex71 wrote:
    not sure how to do what you are asking but if you right click on a cell you need the user to add data to and select add comment you can add instrustions on how that cell is to be filled in there, when you click on that cell , the comment will pop up telling the user what to do.

    Thanks but that isn't really what I want to do. Just a simple pop up message box on opening the file is all I want. I'm sure it's possible.


  • #4
    alterneight
    Closed Accounts Posts: 4 ✭alterneight


    Try the following.
    To access the Open event of a workbook:

    1. Right click the small Excel icon next to File on the main toolbar.
    2. Select Workbook from the left dropdown.
    3. You should now see the following code:

    Private Sub Workbook_Open()

    End Sub

    Change this to something like the following:

    Private Sub Workbook_Open()
    MsgBox "Please fill in the cells highlighted pink"
    End Sub

    Close out and save. You can change the text then afterwards to say whatever you want. It could also be worth bearing in mind that it could be useful to use Validation on cells so that users are restricted to entering numbers/text/days of year etc.

    You can select this in Data>Validation so that if a wrong value is entered it will display an error message.

    HTH


  • #5
    i71jskz5xu42pb
    Closed Accounts Posts: 1,806 ✭✭✭i71jskz5xu42pb


    dannyd20 wrote:
    Thanks but that isn't really what I want to do. Just a simple pop up message box on opening the file is all I want. I'm sure it's possible.

    Tools/Macro/Visual Basic Editor

    Define a sub routine for the Workbook on open event as follows

    Private Sub Workbook_Open()
    MsgBox ("This is not an alert")
    End Sub


  • #6
    dannyd20
    Registered Users, Registered Users 2 Posts: 345 ✭✭dannyd20


    Thanks alterneight & PaschalNee - thats what I was looking for. I knew it was there somewhere!!


  • Advertisement
Advertisement