EXCEL VBA UserInterfaceOnly:=真不起作用 [英] EXCEL VBA UserInterfaceOnly:= True not working

问题描述

当我使用(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:=真不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！