Excel Start up message

[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

 

[Guest]

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

 

[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