I have created a spreadsheet to track contractor's
submittals (shop drawings) in our office. Mostly this
involves alot of date arithmetic. One of the features of
the sheet is that I can add a new line for resubmittals.
I wrote a macro that creates a new line and then copies
formulas into the new line. To simpify the process I
created a button which is attached to the file.
The problem is that I created the original spread sheet in
Excel 5.0. In 5.0 I can select a cell, hit the button and
the new line is created under the selected cell. In 2000
when I hit the button the new line is created in a cell
under the button!!!! Any Ideas???