2010 Shared Workbook Woes - Urgent Please Help

[moorelgm]

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.

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=494596

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the original thread.