I just upgraded to Excel 2010 and noticed the following immediately.
When I place an ActiveX control (e.g. a command button) on the worksheet, and then share the workbook, the button does not work any longer (as if it never gets pressed).
The control works fine in the un-shared workbook.
I do not see this behaviour in Excel 2003 or 2007.
Can someone please explain what is happening and a possible solution.
I have many Excel 2003 Workbooks with these controls but the buttons do not work when I bring them into Excel 2010 shared workbook.
Thanks for your help in advance.
When I place an ActiveX control (e.g. a command button) on the worksheet, and then share the workbook, the button does not work any longer (as if it never gets pressed).
The control works fine in the un-shared workbook.
I do not see this behaviour in Excel 2003 or 2007.
Can someone please explain what is happening and a possible solution.
I have many Excel 2003 Workbooks with these controls but the buttons do not work when I bring them into Excel 2010 shared workbook.
Thanks for your help in advance.
