ExcelBanter - Hide and show ribbon excel 2013 using vba

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hide and show ribbon excel 2013 using vba (https://www.excelbanter.com/excel-programming/450215-hide-show-ribbon-excel-2013-using-vba.html)

Mark Stephens

Hide and show ribbon excel 2013 using vba

Now MS have apparently nixed the excel4macro option (Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)") does anyone know a way of doing this, it should be easy right?

Any help/pointers appreciated.

M.

Peter T[_7_]

Hide and show ribbon excel 2013 using vba

"Mark Stephens" wrote in message
Now MS have apparently nixed the excel4macro option
(Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)") does
anyone know a way of doing this, it should be easy right?

Any help/pointers appreciated.

It works fine for me in 2007, 2010 and 2013, where have you read it
documented that it no longer does.

Regards,
Peter T

All times are GMT +1. The time now is 10:00 PM.