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?
I have a worksheet to which I often want to add new lines, w/ selective copying of formulas, formatting, etc. for certain columns. To do that, I created a User Control (button) and attached a VBA macro that will prompt me w/ an Input Box for how many rows to add, then add them w/ the proper formatting, etc. If you are familiar w/ recording and modifying macros, it should be relatively easy to create something similar for your purpose that will first unprotect the sheet, then re-protect it after the rows have been added.
- Keyboard Shortcuts: