Trust Center Settings check within VBA

[moogthemoog]

Hi

I have VBA that will save a worksheet as an .xlsm, but this will cause problems on those users who have not enabled Macros in their Trust Center settings.

My thought was to have an If..Then statement so that the VBA could detect the status of the Trust Center macro settings, and save as .xlsx if macros are disabled or .xlsm if enabled.

Is there a way of identifying this status within VBA?

Thanks
Jon

 

[moogthemoog]

This may be a illogical post, as presumably if the macros are disabled, the VBA won't run in the first place! Apologies if so.