MasterBash
New Member
- Joined
- Jan 22, 2022
- Messages
- 11
- Office Version
- 365
- 2019
- Platform
- Windows
I have 2 tables on 2 different sheets with 10 columns each and 6 of the 10 columns have INDEX formulas. Both sheets have the same table headers.
I would like to protect the columns that have a formula in them while keeping the table expandable. So if I can somehow add a row to the table, the formulas need to be autofilled in the cells too. Exactly like it would normally happen if it were not protected...
In other words, I need to protect 12 columns spread inside 2 tables with the exact same headers on 2 different sheets so people dont mess with the formulas.
How can I do that? I believe I would need a VBA script, right?
I would like to protect the columns that have a formula in them while keeping the table expandable. So if I can somehow add a row to the table, the formulas need to be autofilled in the cells too. Exactly like it would normally happen if it were not protected...
In other words, I need to protect 12 columns spread inside 2 tables with the exact same headers on 2 different sheets so people dont mess with the formulas.
How can I do that? I believe I would need a VBA script, right?