Excel中的复选框和按钮停止工作在S preadsheet [英] Excel checkboxes and buttons stopped working on spreadsheet

问题描述

我有一个使用宏A S preadsheet。它一直在努力罚款多年来，它一直是XLSM将近一年了。它使用按钮和复选框控制的宏。就在上周，所有的复选框和按钮停止工作。我们取代了按钮，现在他们的工作，但复选框会比较难以取代，所以我希望有办法解决这些问题。

I have a spreadsheet that uses macros. It has been working fine for years, and it has been an xlsm for almost a year now. It uses buttons and checkboxes to control the macros. Just last week, all of the checkboxes and buttons stopped working. We replaced the buttons and now they work, but the checkboxes would be more difficult to replace so I was hoping there was a way to fix them.

在上面的图像时，左手侧示出了这个新的行为，其中该复选框不能进行检查。相反，光标显示为一个大的加，并显示复选框的值。

In the image above, the left-hand side shows this new behavior, where the checkbox cannot be checked. Instead, the cursor shows up as a large plus and it displays the value of the checkbox.

在右边的是在S preadsheet其中正确的行为exhibitied的早期版本。光标变成一个箭头和允许用户检查。

On the right is an earlier version of the spreadsheet where the correct behavior is exhibitied. The cursor becomes an arrow and the user is allowed to check.

请注意，我的不是在设计模式的

当我进入设计模式，右键点击复选框，然后进入属性，也有复选框没有属性。当我选择在属性窗口顶部的下拉菜单，复选框不在项目列表。的按钮，这是目前运行它们被替换后，不要在下拉列表中显示无论是。在旧小号preadsheet这样的作品，所有按钮和复选框中列出。

When I enter design mode, right click on the checkbox, and go to properties, there are no properties for the checkbox. When I select the dropdown menu on the top of the properties window, the checkboxes are not in the list of items. The buttons, which are currently functioning after they were replaced, do not show up in the dropdown list either. In the old spreadsheet that works, all buttons and checkboxes are listed.

任何帮助将是最AP preciated。

Any help would be most appreciated.

谢谢！

原来的问题，现在在谷歌来了和我没有，所以我同意复制。感谢您的帮助。

The original question comes up in Google now and mine does not so I agree duplicate. Thanks for the help.

推荐答案

PNUTS评论解决了这个问题。我不得不删除我的.exd文件，因为在2014年12月更新搞砸功能。

pnuts comment solved the problem. I had to delete my .exd files because the December 2014 update messed up the functionality.

<一个href=\"http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx\" rel=\"nofollow\">http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx

我希望其他人发现通过邮局链接的解决方案。

I hope others find the solution linked through the post.

这篇关于Excel中的复选框和按钮停止工作在S preadsheet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！