Groups
Sign in
Groups
EXCEL函數與VBA設計
Conversations
Labels
About
Send feedback
Help
EXCEL VBA動態取消工作表保護與VBA專案保護設定
98 views
Skip to first unread message
吳老師
unread,
Nov 19, 2017, 3:23:51 AM
11/19/17
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to EXCEL函數與VBA設計
EXCEL VBA動態取消工作表保護與VBA專案保護設定
完整連結:
https://terry55wu.blogspot.tw/2017/11/excel-vbavba.html
若設定了工作表保護之後,
無論是人工輸入或是VBA輸入,
但會失敗,VBA則會跳出錯誤畫面,
因此,可以動態的將保護取消,之後再動態的加上保護,
ActiveSheet.Unprotect ("1234")
不過,因為會需要將密碼寫到程式之中,
所以保護VBA專案裡的程式碼,又是另一個問題,
因此,此次的分享主要是如何VBA動態取消工作表保護與VBA專案保護設定。
吳老師 2017/11/19
Reply all
Reply to author
Forward
0 new messages