Forum Discussion
Ned_O
Sep 18, 2021Copper Contributor
Automatic Row Addition
I have a relatively simple mileage log that does some automatic calculations. Basically, all I need to do is fill in a date and the ending mileage and everything is calculated. I've also created ...
NikolinoDE
Sep 21, 2021Platinum Contributor
Thanks for the file that makes it a lot easier.
But please mark all cells that you would like to have blocked with a yellow background. So I can unlock all other cells for you and lock the yellow ones.
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
But please mark all cells that you would like to have blocked with a yellow background. So I can unlock all other cells for you and lock the yellow ones.
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
Ned_O
Sep 21, 2021Copper Contributor
I've yellowed the protected cells. I protected them from FORMAT CELLS.
The problem is once I turn on Protect Sheet, I can no longer automatically add rows to the bottom of the sheet. Instead, it goes back to the top.
Thanks,
ned