Excel Start up message

K

Ket

Hello,

I am using excel XP on windows XP.
Is it possible to have a message box pop up when starting an excel
worksheet. This message box would have some key information regarding
the worksheet and the user would need to Ok this message to continue.
If they did not choose OK the spreadsheet will not open?

TIA

Ket
London
 
L

LanceB

You could put it in a workbook open event

Private Sub Workbook_Open()
If MsgBox("hello", vbOKCancel) <> 1 Then
Application.ActiveWorkbook.Close
End If
End Sub

Lance
 
K

Ket

Works a treat - Many thanks Lance


You could put it in a workbook open event

Private Sub Workbook_Open()
If MsgBox("hello", vbOKCancel) <> 1 Then
Application.ActiveWorkbook.Close
End If
End Sub

Lance
Click to expand...
 
Top