[RESOLVED] MSG on Workbook Open event EXCEL VBA

[billhuard]

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.

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??

[DKenny]

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.

[Comintern]

You could just turn on automatic calculation instead:

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