We have an Excel spreadsheet with an ActiveX control on one of the VBA forms. We are getting an ActiveX security warning popup - this is expected and perfectly fine. The odd thing is that sometimes the warning appears when you first open the workbook, and sometimes it doesn't appear until the form the control is used on is opened.
As the form isn't always used it is better if the warning only appeared when the form is opened. Is there any way of forcing this behaviour, instead of the random behaviour we currently have?