Thanks for suggestion.

Question. If I create a button using the controls tool box, will the
sheet be compatible with the user running Excel95?

Problem: I created button using controls tool box as suggested, but for
some reason the original macro code would no longer run correctly. I
need to debug.

Observation: Button created using FORMS tool seems to be associated with
the row of the spreadsheet where it was located when the form was created.

Planned Approach: To get around problem, I'm going to try placing all
the "buttons" in a custom tool bar. That way they should not end up
being associated with a specific row on a sheet.

Buczacz

wrote:
Maybe using the control toolbox to create your button
would work rather than the forms toolbox. You will need to
enter the name of your macro within the _click macro for
the button to work.



-----Original Message-----
I've spent lots of time looking at this with zip

results. Perhaps one

of the pros that read this post can tell me what I'm

doing wrong.

In a macro written using Excel95 I decla

Public IDN As Integer
Then in the macro "Contact_History" I use the

command:

IDN = ActiveSheet.Cells(ActiveCell.Row, 1).Value

The macro is activated by clicking a SOFTWARE button

assigned to the

macro "Contact_History" positioned in the top row over

cell B1.

When using EXCEL95, when I click on the SOFTWARE button

assigned to the

macro "Contact History," The macro runs and IDN is the

value in the

first column of the row containing the active cell as

expected.

When using EXCEL97, when I click on the SOFTWARE button

assigned to the

macro "Contact History," The macro runs and IDN ends up

being the value

of the first column of the TOP row. After the macro has

run, the

selected cell is no longer the initially selected cell;

it is now the

top left cell.

When I run the macro from the pull-down tools menu, the

macro runs

correctly. Furthermore, the initially selected cell

remains the

selected cell after the macro has run.

It seems that in my version of Excel97, the action of

clicking on the

SOFTWARE button also makes the underlying cell the active

cell.

Can anyone offer a suggestion as to how to get out of

this problem other

than by the elimination of the SOFTWARE button?

WindsurferLA


.