View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default command button help


Private Sub CommandButton2_Click()
'Closes another open workbook without saving

Workbooks("Test.xls").Close SaveChanges:=False

End Sub

Private Sub CommandButton3_Click()
'Closes the workbook containing the _
macro code without saving

ThisWorkbook.Close SaveChanges:=False

End Sub

--
Regards,

OssieMac