Oliver Dewar
Board Regular
- Joined
- Apr 17, 2011
- Messages
- 201
Hi All.
I have an excel app that uses several active x controls. The system can work for days without issue... even weeks. Then suddenly, a macro that's been run thousands of times runs... and the active x controls become rectangles with a red x in the corner.
Its like they simply didn't render correctly, because you can still click on them and they work just fine!
I saw another thread that's similar, but unresolved:
http://www.mrexcel.com/forum/showthread.php?t=523644
I'm not worried about stopping this happening (unless someone already knows the solution) because it seems to be an excel bug... I'd like to know if anyone's found a way to 'refresh' the active x rendering, so I can include a form button to refresh, and therefore continue on without having to close and reopen the workbook as we do now.
Cheeeeeers all!
Excel 2007 - Windows 7.
I have an excel app that uses several active x controls. The system can work for days without issue... even weeks. Then suddenly, a macro that's been run thousands of times runs... and the active x controls become rectangles with a red x in the corner.
Its like they simply didn't render correctly, because you can still click on them and they work just fine!
I saw another thread that's similar, but unresolved:
http://www.mrexcel.com/forum/showthread.php?t=523644
I'm not worried about stopping this happening (unless someone already knows the solution) because it seems to be an excel bug... I'd like to know if anyone's found a way to 'refresh' the active x rendering, so I can include a form button to refresh, and therefore continue on without having to close and reopen the workbook as we do now.
Cheeeeeers all!
Excel 2007 - Windows 7.