Incompatibility between Excel97 and Excel95 macros

[buczacz]

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 declare:

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

 

[Guest]

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.

 

[buczacz]

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