Creating a pop up window.

[drag-driver]

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.

[Audiojoe]

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 ]

[drag-driver]

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

[Audiojoe]

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

[Paul B]

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

[drag-driver]

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 wíll be, i want the message box to show the current settings, ie referance to cells which have the possibilyty of being changed