I have tracked down a strange problem with my excel macro. In this macro I have lots of activeX command buttons and other objects on my sheet. It also has a number of userforms as well.

If you doubleclick to start this xlsm script the program is running smoothly without fault. If I start up excel.exe then select OPEN to start this script it will also run without problem.

However, if I go to my excel.exe directory and start it like this in a command prompt - excel.exe myscript.xlsm then strange thing happens. All my userforms in the script behave normally but all my activeX control objects on my sheet are frozen. They look to be enabled but cannot be clicked or manipulated - as if they are all disabled.


If I interrupt my script in such a state and click the "reset" button in visual basic editor and run my script again those activeX control objects would all work right away. Anyone has any clue to what could be the culprit?