Creating a pop up window.
Creating a pop up window.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Creating a pop up window.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What i need to do is----------create a pop up window which apears every time the file is opened telling the person whats the settings on the file is.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No worries, put this into the workbook open event:


    Private Sub Workbook_Open()

    MsgBox "Don't forget that this workbook has a special code which enables this message box"

    End Sub



    If you want it for every worksheet, try this:

    Private Sub Worksheet_Activate()

    If Range("A1").Value <> "off" Then MsgBox "Don't forget that this sheet has a special code which enables this message box"

    End Sub

    Now if you want to disable it for some sheets, just put any number in A1 of that sheet

    Hope this helps

    [ This Message was edited by: Audiojoe on 2002-03-20 08:18 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Workbook open - event? Where exactly do i put the above code

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Righto,

    Go into your workbook and press ALT+F11. Now on the left it should have icons for SHeet1, Sheet2, Sheet3 and This Workbook

    Double click "This Workbook", then at the top of the blank page you'll see two drop down boxes. One says General, and the other one says Declarations. You change the General one to 'Workbook' and paste the code onto the blank page

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put it in thisworkbook code right click on the excel icon, top left next to file then view code

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how can i make this message box which apears show the current settings ie when someone has made shanges to the setiings saved and exits and the next person who uses the program will want to know what the new settings wll be, i want the message box to show the current settings, ie referance to cells which have the possibilyty of being changed

User Tag List

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