I have a macro that uses a change event that runs fine on all
computers except one. Can anyone give me any reason why this does not
work? I have trusted access to VBA in the security settings.

I have stepped though the code and it seems to be doing what the code
says, but nothing changes on the worksheet. And this is the only
computer that has this issue. All other machines run this change
event perfectly. All operating systems are the same as are the Excel
year.

thanks is advance,
Jay

On the affected machine you have set a break point in the code and triggered
the change event from the sheet. When you then step through the code from
that point are any changes being made? If you add a message box does the
message box fire?

--
HTH...

Jim Thomlinson


"jlclyde" wrote:

I have a macro that uses a change event that runs fine on all
computers except one. Can anyone give me any reason why this does not
work? I have trusted access to VBA in the security settings.

I have stepped though the code and it seems to be doing what the code
says, but nothing changes on the worksheet. And this is the only
computer that has this issue. All other machines run this change
event perfectly. All operating systems are the same as are the Excel
year.

thanks is advance,
Jay
.

Jim, I have set a breakpoint and until now I had not put in a msgBox.
I just put int eh MsgBox and it fired just like it is suppoed to. It
still skips all of the other steps that I ahve asked the macro to
perform. When stepping through, it goes through line by line, but not
of the tasks are performed. any thoughts?

Thanks,
Jay