Automatic Row Addition

%3CLINGO-SUB%20id%3D%22lingo-sub-2762790%22%20slang%3D%22en-US%22%3EAutomatic%20Row%20Addition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2762790%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20relatively%20simple%20mileage%20log%20that%20does%20some%20automatic%20calculations.%20Basically%2C%20all%20I%20need%20to%20do%20is%20fill%20in%20a%20date%20and%20the%20ending%20mileage%20and%20everything%20is%20calculated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20also%20created%20the%20spreadsheet%20so%20that%20rows%20add%20to%20the%20bottom%20of%20it%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20when%20I%20switch%20into%20Protect%20Sheet%20(all%20the%20automatic%20calculations)%2C%20it%20won't%20add%20rows%20to%20the%20bottom%20of%20the%20worksheet%20any%20longer.%20Is%20there%20a%20way%20to%20make%20that%20happen%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20ned%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2762790%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2762854%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20Row%20Addition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2762854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159669%22%20target%3D%22_blank%22%3E%40Ned_O%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EI%20don't%20really%20know%20what%20your%20plans%20are%2C%20because%20you%20haven't%20inserted%20a%20file%20(without%20sensitive%20data).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EBut%20it%20is%20possible%20to%20do%20this%20in%20different%20ways.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ELock%20%2F%20unlock%20with%20VBA%20code%20or%20with%20single%20cells.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EAs%20I%20said%2C%20without%20a%20file%20(without%20sensitive%20data)%20where%20you%20explain%20your%20plans%20exactly%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eit%20would%20be%20very%20time-consuming.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIt%20would%20be%20advantageous%20to%20know%20the%20Excel%20version%20and%20operating%20system.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHere%20is%20some%20information%20on%20how%20you%20can%20best%20present%20your%20project%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eso%20you%20will%20get%20a%20much%20faster%20and%20more%20accurate%20answer%20that%20best%20suits%20your%20project.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 the spreadsheet so that rows add to the bottom of it automatically.

 

The problem is when I switch into Protect Sheet ( to protect the automatic calculations), it won't add rows to the bottom of the worksheet any longer. Is there a way to make that happen?

 

Thanks, ned

4 Replies

@Ned_O 

I don't really know what your plans are, because you haven't inserted a file (without sensitive data).

But it is possible to do this in different ways. Lock / unlock with VBA code or with single cells.

 

As I said, without a file (without sensitive data) where you explain your plans exactly,

it would be very time-consuming.

It would be advantageous to know the Excel version and operating system.

 

Here is some information on how you can best present your project,

so you will get a much faster and more accurate answer that best suits your project.

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

Thanks, NikoolinoDE. I've added the file.

I'm simply wanting additional rows to appear at the end when I tab forward. This only happens when I'm not Protecting the Sheet.

I'm not sure what "Lock / unlock with VBA code or with single cells" means.

Thanks! ned
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)

@NikolinoDE 

 

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