Forum Discussion
TonyCrabb
Apr 29, 2022Copper Contributor
How can i protect a calculated column in a table from being edited but allowing users to add rows?
Hi, I have a simple example of a data entry form (on an excel table) with 4 columns for entry of quarterly financial data. i have a 5th column that adds up the 4 quarters into an annual cost per line...
HansVogelaar
May 04, 2022MVP
You can remove the Beep line and change Range("A1").Select to Range("E" & Target.Row).Select
TonyCrabb
May 04, 2022Copper Contributor
Thanks HansVogelaar - you have been very helpful. I need to sleep on this one and have a think about where to go next.