Question

VBA大神啊，每当关闭工作簿时，将sheet1和sheet3自动打印成PDF格式，怎么设置呢

就是要打印我指定某几个工作表

Answer 1

可使用BeforeClose事件，前提是已经安装了PDF打印机：

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheet1.PrintOut (ActivePrinter:= PDF打印机的名称)

Sheet3.PrintOut (ActivePrinter:= PDF打印机的名称)
End Sub