Do not show this message again

  • Thread starter Thread starter Tendresse
  • Start date Start date
T

Tendresse

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock userform for editing 2
Where did my question go? 3
Active Workbook 2
Position of selected rows 5
Input Box - Type mismatch 2
select a cell with specific value 8
Compare values in a column 4
display message box in excel(2003) using VBA word(2003) 0

Back
Top