[RESOLVED] MSG on Workbook Open event EXCEL VBA

I Got message displayed to the user every time the workbook is open.
So I putted it in the Workbook Open sub in the ThisWorkbook.

VB Code:

Private Sub Workbook_Open()
Msgbox "To fully automate this workbook, automatic calculation must be ON"
End Sub

Everything works fine.

Now want I want to do, is to put a checkbox witch the user can check to not display this message anymore.

Is it possible?? How??

Bill
You will need to build a Userform if you want to include a checkbox control.
I would suggest that you store the value of the checkbox in a user-defined name within the workbook. Then when the book is opened, you can evaluate that name to see if you need to display the form.

You could just turn on automatic calculation instead:

VB Code:

Private Sub Workbook_Open()
 
    Application.Calculation = xlCalculationAutomatic
 
End Sub