Protect an Excel VBA Project - Hide VBA Code from Users

preview_player
Показать описание
This video demonstrates how to protect a VBA project so that code is hidden from users. This might be important if the code contains passwords etc. This video will be useful to you if you are asking the following questions.

Can you password protect VBA code?
How do I hide VBA code in Excel?
How do I password protect a macro code?
------------------------
Рекомендации по теме
Комментарии
Автор

You should add the disclaimer that it is still possible to view the code. It's annoying but you can save the workbook as a zip file by changing the extension, open it with a hex editor, change a couple things, change the extension back to Excel, and open the VBA project.

twiddle
Автор

Hi, Thanks for your video. After entry cell locks but when I delete the number and the cell is empty the also cell is locked. Please can I know how to set up when the cell is empty, cell is unlocked and after empty cell lock.

deepakl
Автор

How to run the macro when the VBA code is lock or project code is locked. My macros are not working siting error that project code is locked

arpitdhobe