I'm working in Excel 2000 (I know -- first mistake) on a spreadsheet that I wanted protected (for the formulas), but the user has to be able to add a row and copy the formula that is in the row above, down into the row they just inserted.
The sheet consists of six columns, with different formulas in each. If you were just working on the sheet, you would select the bottom cells of the row and use the handle to drag the formulas down one row. The code can't refer to static cell labels because rows will be inserted and deleted from the sheet.
So I think I need a macro that will: (1) unprotect the password-protected sheet; (2) insert a row above the current insertion point (3) copy the formulas down from the row above and then (4) password protect the sheet again.
Doesn't seem that tough, but I don't work with this stuff enough to keep sharp. Thanks.
The sheet consists of six columns, with different formulas in each. If you were just working on the sheet, you would select the bottom cells of the row and use the handle to drag the formulas down one row. The code can't refer to static cell labels because rows will be inserted and deleted from the sheet.
So I think I need a macro that will: (1) unprotect the password-protected sheet; (2) insert a row above the current insertion point (3) copy the formulas down from the row above and then (4) password protect the sheet again.
Doesn't seem that tough, but I don't work with this stuff enough to keep sharp. Thanks.