vba 如何删除求解器(SOLVER.XLAM)代码
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/15545188/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to delete Solver(SOLVER.XLAM) code
提问by user2151190
opening several examples of written macro's/ codes I suddenly get stuck with a code that seems to be secured. Solver (SOLVER.XLAM) This is doiing noting and I would like to remove that from my system. I guess this is not a relavant code . Can anybody tell me what I should do? I already installed something to remove passwords but the SOLVER is still asking for passwords and I can not get rid of it!
打开几个编写宏/代码的例子,我突然被一个似乎是安全的代码卡住了。求解器 (SOLVER.XLAM) 这是在注意,我想从我的系统中删除它。我想这不是一个相关的代码。谁能告诉我我该怎么做?我已经安装了一些东西来删除密码,但求解器仍在要求密码,我无法摆脱它!
采纳答案by Kazimierz Jawor
Solver is Excel add-in. If you want to remove it go to Excel Application > Options > Search for add-ins > Press something like 'go to' button > un-check Solver on the list (I can't give you exact path as I have Polish version of Excel).
求解器是 Excel 插件。如果要删除它,请转到 Excel 应用程序 > 选项 > 搜索加载项 > 按“转到”按钮之类的东西 > 取消选中列表中的求解器(我无法为您提供确切路径,因为我有波兰语版本的excel)。
It's better not to try to open Solver's VBA code as it is rather copyright protected.
最好不要尝试打开 Solver 的 VBA 代码,因为它受版权保护。
Moreover, I don't think Solver makes any inconveniences when working with Excel or VBA.
此外,我认为 Solver 在使用 Excel 或 VBA 时不会带来任何不便。
回答by user2151190
verry nice, now it is not more active. For the one who want to deactivate this you should follow the next steps. For Excell 2010. Open Excell/go to options/ go to add ins/ go to active add ins on top of the page / select the SOLVER / press start (down the page)/ then a window will pop up so that you can uncheck or check it as you require. That was verry easy to do. Thank you Kaz for pointing me to the right direction! It is better to not delete them, maybe you will need them later
非常好,现在它不是更活跃了。对于想要停用此功能的人,您应该按照以下步骤操作。对于 Excell 2010。打开 Excel/转到选项/转到加载项/转到页面顶部的活动加载项/选择求解器/按开始(页面下方)/然后会弹出一个窗口,以便您可以取消选中或根据需要进行检查。这很容易做到。感谢 Kaz 为我指明了正确的方向!最好不要删除它们,也许你以后会需要它们