Macro to Protect unprotect tables

[graiggoriz]

Hello,

I have 4 tables (Table1, Table2, Table4 and Table5). I need to unprotected the cells in those 4 tables and protected them back.

Would you know how to do that? I would need that macro to insert it in my existing one.

many thanks in advance,
Graig

[Leith Ross]

Hello graiggoriz,

The macro code below can be called from your current macro. You should change the password, worksheet name, and table names to match what you will be using.

Add a new VBA module to your workbook and paste the code into it. Add calls to this macro in your existing code where needed.

Please Login or Register  to view this content.

Calling Examples

Please Login or Register  to view this content.