As always your tips are valuable.
Concerning to this topic I have a question that I hope you can answer.
I use tables very often. Recently I needed to share a worksheet where I have some columns with validation and calculations based on data from other columns in same line (something month and quarter based on data).
I want to allow user to add new lines to this table. Excel copies rules from line above and this is works fine.
In dont want to allow users to override formulas but to input new lines.
When I protect worksheet user can not add new lines!
Do you know how to deal with this?
Keep Up with TechRepublic