Minimize Ribbon

[ExcelRoy]

Hi all,

could i please ask for a line of code to minimize the ribbon, then to expand the ribbon

Only to minimize and not remove

Many thanks

 

[ExcelRoy]

Hi Eric W,

Sorry but this doesn twork, but JoeMo's alternative does

just curious though, if you click save it unhides everything, should this happen?

Thanks

 

[JoeMo]

Hi JiMoe,

Maybe I was a bit forward as I cannot seem to get it working, could it be because I am using 2007?

Thanks

See my response in post #8 - offers another alternative which I think will work in xl2007.

 

[ExcelRoy]

Hi JoeMo,

Yes, sorry I didn't refresh, I missed the alternative which works fine, but if I click save it unhides everything

Thanks again

 

[JoeMo]

Hi JoeMo,

Yes, sorry I didn't refresh, I missed the alternative which works fine, but if I click save it unhides everything

Thanks again

That's not the case for xl2010, so I have no way to find a solution to that. Did you comment out Eric W's line before you saved to see if that has an effect?