Hide Ribbon

Dear all
I have a file in excel which I want when user open it the ribbon will be hidden
I have a code for hidden the ribbon but I don't know how I can run it on open the file automatically not by hand
so I want when file opened the code (hidden the ribbon)will run
thanks in advanced for your answering

Add the below code in ThisWorkbook Code Window. This will even turn off the quick access tool bar too..

Please Login or Register  to view this content.

Dear Sixthsense
at first thanks for your answering
but I try and it is not working , when I open the file ribbon was shown plz help
could you plz answer me by file(in excel)

You should paste the code in ThisWorkbook code window.

To Add Excel VBA Code to a Workbook / This Workbook Module

1. Copy the code that you want to use
2. Select the workbook in which you want to store the code
3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
4. In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
5. Right-click on the ThisWorkbook object, and choose View Code
6. Where the cursor is flashing, choose Edit | Paste

Dear Sixthsense
I do step by step what you say but it is not working
I attach my sample file and the code which you suggest
plz try it
I copy and past your code so when you download an open it , it must be worked (hide the ribbon) but it is not working

Nope, In your attached file still the suggested code resides in a Module. Please move the code to this workbook code window instead of keeping it in module.

Please refer post #4 once again to know how to add the code in This Workbook Code Window.

Glad it helps you and thanks for the feedback