VBA code to automatically lock a table on excel

**ENOCH ANTWI** · 01-04-2016, 02:45 AM

Please can any body help me to write a VBA code that locks an excel table and still the table canbe updated from its original source.

**Fettertiger** · 01-10-2016, 03:11 PM

Hi Enoch Antwi,

just insert the following line in your code (replace "MyPassword" with your password, or leave this part blank if its not required)

Please Login or Register  to view this content.

To Unprotect use the following code:

Please Login or Register  to view this content.

Theo

Re: VBA code to automatically lock a table on excel