Hey Steve
I download and tried it. The cell protection function is staying the same, that much is true. But nothing is happening when the last cell changes in the target column. That is why I keep asking the same Question
can you go into depth a little about the arguments?
If I could just get a better understanding of what is being attempted I could figure out what I need to mod to make it work the way I need.
When I enter data nothing happens, the active cell jumps to home (1st cell in the data entry range) no insert, no copy, nothing.
Let me try to explain differently; Six of the sheets will change by the users data entry, here is just one of them.
Sheet7; B2:K~(~ = However many rows needed)B2:K8 locked =header info
B9:H~ unlocked =data entry for user
I9:K~ Locked & Hidden =auto functions & formulas
Last 3 rows in the sheet are the totals
G~:K~ locked =totals data is transferred to Statement (sheet1)
Columns "B-D" always have data, "E:H" can have data (one must), "I" and "J" are conditional (depending on the entry in column "B", "K" is the total of the row from "E:J" (it also totals on condition of the status of "B")Column formats:
"B" = Number, Validation (Tax code setting based on sheet2)
"C" = Date
"D" = Text (receipt details)
"E:H" = data entry, Currency, (always accessible to the user, Once completed the whole workbook will be locked and password protected, havent got that far yet)
"I:K" = Row SubTotals & Totals, Locked, Hidden.
The type of career this Expense workbook is for is not the usual you may have seen. Myself and a number of my friends have worked in Heavy Construction, We work in different parts of the country during the same year. Tax codes and rates change for the area we are in, (I have worked in as many a 9 states in one year) I have never been able to find any Program (or for that matter) a CPA that fully understands the Deductability of any thing you spend when you are out in the field. And none of my friends have either. The State and Federal Tax codes change all the time and It really affect those of us who travel from state to state (even county to county).
So we need to be able to Itemize every penny and place it in the right category for our tax's to work out right.
edit, Also I am the only one, of all of my friends that has experiance with coding and App development, (and I am pretty Green when it comes to VBA and the .NET platform)