I was wrong. This is what happens. No matter what i do, if i have other workbooks open it closes them also.
here is the code i tried
Private Sub CommandButton35_Click()
' ActiveSheet.Protect Password:="7863396789", DrawingObjects:=True, Contents:=True, Scenarios:=True _
'ActiveSheet.EnableSelection = xlUnlockedCells
'ActiveWorkbook.Save
Workbooks("Bid Schedule.xlsm").Close SaveChanges:=True
'ActiveWorkbook.Close
' Unload Me
End Sub