neodjandre
Well-known Member
- Joined
- Nov 29, 2006
- Messages
- 950
- Office Version
- 2019
- Platform
- Windows
This is quite annoying and i am sure it's going to help others as well - it took me 1 hour to figure this out and thank god I found this quite early because I was getting very annoyed..
The problem: A perfectly working complicated macro was running fine in all Excel versions.
However, in Excel 2010 I came up with the error "571221" Application-defined or Object-defined Error when trying to make a sheet visible.
The culprit... ActiveX controls in the Trust Center were disabled...
no idea why.. when i set the ActiveX settings to "Prompt me before enabling all controls with minimal restrictions" the macro works perfectly fine again..
So my question to you guys is:
1. why does this happen?
2. how can i write macro code to check the ActiveX setting and if it's set to "Disable all controls" prompt the user to change this?
many thanks
Andy
The problem: A perfectly working complicated macro was running fine in all Excel versions.
However, in Excel 2010 I came up with the error "571221" Application-defined or Object-defined Error when trying to make a sheet visible.
The culprit... ActiveX controls in the Trust Center were disabled...
no idea why.. when i set the ActiveX settings to "Prompt me before enabling all controls with minimal restrictions" the macro works perfectly fine again..
So my question to you guys is:
1. why does this happen?
2. how can i write macro code to check the ActiveX setting and if it's set to "Disable all controls" prompt the user to change this?
many thanks
Andy
