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:

Please Login or Register  to view this content.

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

Luke,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

Please Login or Register  to view this content.

This adds 2 properties to the Thisworkbook object, which allows you to minimize or remove the ribbon.