Hi there!
I'm looking for some help so *I* can help a coworker. For the record, the file was created by my coworker, and I left everything (basically) as it was when she sent it to me. (I say that because I feel like it's kind of sloppy, so y'all might think so, too. Haha! Once I'm able to sort out the issue I'm writing about, I'll clean up the mess.)
Several (not-so-Excel-trustworthy) people will be working in it. It will be password protected, and several of the columns are locked because they contain formulas. We need them to be able to insert rows, but the locked cells complicate it.
I need something that will unlock the worksheet, allow for insertion of a row that copies the formulas from the row above it (or below - I'm not sure how that works - or...maybe it's still too early in the morning and my brain's not totally 'on it' yet), then re-lock the worksheet. Also, it should not show any sort of warning/error pop-up box when or after the user inserts the line. Is there a way to make all this happen?
- The columns with formulas are: I, K, P, Q, R, S, and T. The formulas start at row 12.
If the file is just too much of a mess and it would be easier to move or delete rows 1 - 11, I'm totally open to that. Also, the intent is that columns P - T will be hidden. I just unhid them so you could see them.
Thank you!!
I'm looking for some help so *I* can help a coworker. For the record, the file was created by my coworker, and I left everything (basically) as it was when she sent it to me. (I say that because I feel like it's kind of sloppy, so y'all might think so, too. Haha! Once I'm able to sort out the issue I'm writing about, I'll clean up the mess.)
Several (not-so-Excel-trustworthy) people will be working in it. It will be password protected, and several of the columns are locked because they contain formulas. We need them to be able to insert rows, but the locked cells complicate it.
I need something that will unlock the worksheet, allow for insertion of a row that copies the formulas from the row above it (or below - I'm not sure how that works - or...maybe it's still too early in the morning and my brain's not totally 'on it' yet), then re-lock the worksheet. Also, it should not show any sort of warning/error pop-up box when or after the user inserts the line. Is there a way to make all this happen?
- The columns with formulas are: I, K, P, Q, R, S, and T. The formulas start at row 12.
If the file is just too much of a mess and it would be easier to move or delete rows 1 - 11, I'm totally open to that. Also, the intent is that columns P - T will be hidden. I just unhid them so you could see them.
Thank you!!