Hi Dori

The fact that it stops on sheet2 makes me think it has probably failed
for some reason. The error handler has caught it which is why you
haven't been prompted that an error occured. If you post the code you
are using as well as the change event that calls the macros to add and
remove borders I may be able to find the problem.

Regards
Rowan

DORI wrote:
Hi Rowan,
Can I ask you another question?
After I added:
application.screenupdating = false
it works great on my computer (Office XP 2002) but when I opened it on
another computer (Office 2000), when I click on the remove border or create
border macros, it jumps to sheet2, creat or remove borders and then stayes
there. Any idea? How can I fix it as most of users have Office 2000?
Thanks,
Dori

"Rowan Drummond" wrote: