在工作簿workbook_sheetchange事件中使用如下代码:if target = "姓名" or target = "性别" thentarget.font.name = "黑体"elsetarget.font.name = "宋体"end if