I don't think you'll be able to. You can't expect to be able to edit thesheet while VBA is locked up.