How do i write a code to display a message box once an excel file is open
(open event) that allows the user to tick a box if they don't want to see
this message any more.
i'm using Excel 2003.
Many thanks
Tendresse

Hi Tendresse

You can check a cell value in the workbook and if it is not "no" for example
show the msgbox

Private Sub Workbook_Open()
If Sheets("Sheet1").Range("A1").Value < "no" Then
MsgBox "Hi"
End If
End Sub

You can also build a small userform with a tickbox to fill the cell value with this value

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tendresse" wrote in message ...
How do i write a code to display a message box once an excel file is open
(open event) that allows the user to tick a box if they don't want to see
this message any more.
i'm using Excel 2003.
Many thanks
Tendresse