问题描述
当我使用(some code here).copy destination:=(some code there)时.仍然会提示您输入protection issues on cells.基本上，它不会让我的代码运行.
When I use (some code here).copy destination:=(some code there). It will still prompt for protection issues on cells. Basically it just won't let my code runs.
推荐答案
不幸的是，状态UserInterfaceOnly:=TRUE并未存储在文件中-因此，如果重新打开文件，则它将受到完全保护.使用Workbook_Open事件重新应用此保护状态-或取消保护，然后直接在VBA代码中重新保护工作表.
The status UserInterfaceOnly:=TRUEis unfortunately not stored in the file - therefore, if you reopen the file, it will be fully protected. Either use the Workbook_Open event to reapply this protection status - or unprotect and then reprotect the worksheet in your VBA code directly.
有关更多详细信息，请参见 Ozgrid ！
See Ozgrid for further details!
这篇关于EXCEL VBA UserInterfaceOnly:=真不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！