Excel Macro Security - Userforms

Hi there,
I have workbook I created that hides the excel application and opens one of my userforms... everything works as expected except for the first time it is run on another computer.

My issue is that on a first time run, due to Excel security settings... Excel asks if you want to enable macros and/or enable content, after clicking enable, Excel errors on the code line that makes the userform visible.

If I close Excel, end the Excel process on windows and open the Excel workbook again... everything is fine.

What I am wondering, is there a way to check to see if macros and content have been enabled for this workbook? If not, do not open userform... goto another sheet for manual button click to the userform. If it has been enabled, run normally. This is a workbook that will have regular updates... so it will become a first time run often.

Changing the security settings in Excel isn't an option as our company requires it.



All additional computers are running Windows 7 with Microsoft Office Professional Plus 2010.

Thanks in Advance...
CraigsWorld

Originally Posted by CraigsWorld

What I am wondering, is there a way to check to see if macros and content have been enabled for this workbook?

No.

The standard way of getting around this is always showing such a message, but using VBA to hide it straight away. If macros are not enabled, the message will stay in place.
It's not ideal and a birrova fudge, but due to Microsoft security concerns, it is the only way to go.

HTH

DominicB