Excel 2010 command button in shared workbook not working

[penny]

Hello -

I am using Excel 2010. I am using a shared workbook that was originally created in Excel 2003. This workbook has a command button that is supposed to be clicked to open a userform. However, I cannot even click on the button when opening the shared form in Excel 2010. When the form is not shared, the button works fine.

I have no problems with the button when opening the shared form in 2003 or 2007.

Is there anything I can do to make the command button work while the form is shared and while using Excel 2010?

Thank you!

[romperstomper]

If it's an ActiveX button, use a Forms button instead.

[penny]

That did the trick, thank you very much!

[Snowman58]

Sorry to jump into this thread, but I am having exactly the same issue and this is the only thread that I have found that offers any insight.

Are all Activex controls disabled when the workbook is shared?

Is this documented somewhere? (I have not been able to find it!)

Has there been any other solution developed since this was originally posted?

Thanks!

[FDibbins]

Hi and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.