Thank You Gents, fantastic as ever..so many ways to Skin A Cat
On Jul 8, 1:27 am, "Ajit Navre" wrote:
> Hi Dave,
>
> Please take a look at the attached workbook- hope this is what you are
> looking for-
>
> (Start from the ThisWorkBook - WorkBookOpen Event Procedure.)
>
> Regards,
>
> Ajit
>
>
>
Hi Dave,
You have more than a way to achieve this.
It depends how many checkboxes you have.
If you have few, associate the same code with each checkbox :
Private Sub CheckBox1_Click()
If [AL1] = True Then
MsgBox "Please Fill the related Entities Spreadsheet, thanks"
End If
End Sub
(AL1 being t