VBA to hide ribbon (not toolbar) on open workbook, and show on close workboo.

Hello all,
I am trying to VBA to hide the ribbon on opening the workbook, and show on closing. I don't want to hide the toolbar. Ideally I only want it to happen on the workbook I am creating. I currently have:

Private Sub Workbook_Open()
SendKeys "^{F1}"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
SendKeys "^{F1}"
End Sub

But this doesn't show the ribbon on closing, and doesn't only apply it to this workbook.

I'd also prefer it if the code didn't use the F1 toggle, but actually hid the ribbon.

Cheers

Luke