FYI, I solved the problem by using complex "If" statements in
Worksheet_Change to lock and unlaock cells as required.

Thanks for the pointer.

Ian
""Peter Huang"" wrote in message
...
Hi,

I think it is hard to do that, because how can we tell that when we press
Tab how many cells should be skipped.
I think for your scenario, we can try to wrtie a if..endif statement to
judge if we need to fire some event when we use tab to navigate through
the
cells on the sheet.
If you still have any concern, please feel free to post here.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.