Does Excel 2000 have the macro recorder? That is usually a good way to getan understanding of how UI interactions can be translated into VBA.