Disabling all ribbon commands

[Adventure_Harry]

Good day

I have a template sheet where the only thing the user need to do is fill in all the appropriate cells and the click the button that says SAVE to save the file to the right folder and file name.

I want to Grey out the ribbon completely so that user can even change the font or any thing else for that matter. The sheet and workbook is protected. Need a way to stop any unwanted tinkering.

Thank you
Tinkerer Herco

 

[RoryA]

Is it one of the new XML based file formats, or an older .xls/.xlt file?

 

[slinky]

You can hide the ribbon via VBA with the following

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

Turn it back on by swapping FALSE to TRUE..

Taken from http://www.mrexcel.com/forum/excel-...ide-ribbon-others-how-limit-one-workbook.html

 

[Adventure_Harry]

Thanks Guys
Slinky your code worked a charm