Run VBA Code on Protected Worksheet
90 هزار بار بازدید -
11 سال پیش
-
If you try to run
If you try to run VBA code on a protected worksheet, it will only happen if you unprotect it and you'll have to again manually protect the sheet. Sometimes you may forget to do so! Also this process is not quite secure.
Now you can create the unprotection and protection via VBA code or macro and also lock the VBA project from viewing. This gives us a great way to protect our data.
In the second part of the video I show how to run the code without a command button.
VBA code available at: https://www.exceltrainingvideos.com/r...
Now you can create the unprotection and protection via VBA code or macro and also lock the VBA project from viewing. This gives us a great way to protect our data.
In the second part of the video I show how to run the code without a command button.
VBA code available at: https://www.exceltrainingvideos.com/r...
11 سال پیش
در تاریخ 1392/07/17 منتشر شده
است.
90,086
بـار بازدید شده