VBA to only allow the save or save as options: Minimize the ribbon

I would like to design a clean look speadsheet. So, I hide the toolbar ribbon in order to have the whole page visible to the user.

Now, I am wondering if I could only allow user to access the "Save" or "Save As" toolbar without displaying the whole ribbon?

I tried to minimize the ribbon here but it didn't work. It says "Object variable or With block variable not set. This is part of the open event.

Please Login or Register  to view this content.

Am I missing something?

This should work.

Please Login or Register  to view this content.

MinimizeRibbon only hides the ribbon and user can always get it by few key strokes. Do you want to try

Please Login or Register  to view this content.

This will hide the ribbon until another macro is run with true in place of false above.
You can place few buttons on your sheet to add any control you need viz. save, save as...