Asking for help...

[B Squared]

I have a worksheet that is used to request flight legs from my aviation department. At the top of the page, the user can enter the total number of legs (1-10) requested for the trip, and that will populate column A with the entered number of legs, and also through VBA, require that certain fields within those requested leg rows be populated before saving. I have been asked to see if it is possible to hide those rows that are not necessary for a given request. Example, I have 10 rows (with borders) available for the maximum of 10 legs requested; if only 2 legs are requested, is there a way to completely hide the remaining 8, thereby reducing the number of pages on which the request will print?

Thank you in advance for any help!

 

[B Squared]

Caleeco,
This adjustment to the VBA seems to be exactly what the Dr. ordered!
Yes, I think I did this correctly; I have gone through each cell and confirmed locked vs. unlocked...but it still works the same after I protect the sheet; it allows me to add text to an autoheight cell, but once I click out of that cell and try to return it doesn't allow it. When I subsequently unprotect the sheet and review the locked vs. unlocked again for that cell, it is now showing locked...weird. Not a show stopper for this form as far as I'm concerned; I think the user can make reasonable accommodation by using this form as a master and "Saving As" right off the bat, so if they make a mistake, they would always have the master document on which to fall back. I greatly appreciate your help with getting this to where it is...you have been an outstanding and very patient resource!!

Thank You,
B Squared