Worksheet_Change

[maicolpue]

Hi.
I have this instruccion in the sheet declaration. No problem.It works very well
But, when i run it in other computater, it dosn't work.

Where is the problem ??

Thx.

 

[kskinne]

hi

please post back w/ more detail on the differences between the two computers, like what operating systems they are using, and also please post the code that you are referring to. can you pinpoint any certain part of the code that is causing the problem on this other computer?

kevin

 

[maicolpue]

the code is :
Private Sub Worksheet_Change(ByVal Target As Range)
Application.Volatile
If Target.Row = 3 And Target.Column = 3 Then extrae_profes
End Sub

This work on a W2000 Office Xp, but doens't work on W98 Office97

Thx

 

[kskinne]

when you run the macro on the win98 machine, and you get the error msg, does it give you the option to debug the code? if so, when you click 'debug', is there any particular line of this code that is highlighted as the place where the code started to error out?

 

[kskinne]

also, what does 'extrae_profes' refer to in your code?

 

[maicolpue]

"extrae_profes" is another macro.
In W98 no error message is displied, simplily the macro does nothing, or the "change" action is not detected...

Thx...

 

[kskinne]

could you please post the extra_profes code as well - this may have something to do with your problem. since the only thing that you worksheet_change event codes does is call this other macro if you are in a certain target.cell, perhaps we need to be looking at that macro as well

thx
kevin

 

[maicolpue]

The problem is not with the "extrae_profes" macro because when i run it directly

Sub nn()
extrae_profes
End Sub

it's run ok.

 

[kskinne]

then try using a different event to trigger the macro, like Worksheet_Calculate(), and see if you still have the same problem on your win98 machine. not sure why the worksheet_change event would not work on your machine

hth
kevin

 

[maicolpue]

How can I define the _calculate event to trig the macro when there was a change in the "C3" cell ??