excel vba set password

2011-04-28 12:13 am
我想允許別人用我excel file的 worksheet,但不想人家打開我的vba editor( alt+F11 )

如何可以在vba 那裡set password?

thz =]

回答 (1)

2011-04-28 7:10 am
✔ 最佳答案
At the VB Editor menu, click Tools > VBAProject Properties and the Protection tab. Lock viewing > pw > re-confirm > ok.


收錄日期: 2021-04-16 12:38:14
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110427000051KK00791

檢視 Wayback Machine 備份