Heading checkbox in Excel view ribbon.

[Nikhil2803]

Hi Team, I am working on a Excel macros work. While I am working on the sheets, I have enabled the Headings and Formula Bar under View ribbons. The problem is whenever I am opening the excel, every time I have to enabled this manually. I want the headings checkbox to be checked every time a user open this excel sheet. Could anyone help how to achieve this.

 

[RobP]

Hi in your VBA code you can add

Application.DisplayFormulaBar = True

or FALSE to turn it off.

Same for headings :

Application.DisplayHeadings = True

or FALSE for off
Rgds
Rob

 

[Nikhil2803]

Hi in your VBA code you can add

Application.DisplayFormulaBar = True

or FALSE to turn it off.

Same for headings :

Application.DisplayHeadings = True

or FALSE for off
Rgds
Rob

Thank you for the inputs.

 

[RobP]

youre welcome. glad we could help.

thanks for the feedback

Rob

 

[Joe4]

Please note that when marking a post as the solution, please mark the actual thread that contains the solution (not your own post acknowledging that some other post is the solution).

You will notice that once you mark a post as the solution, it also appears at the very top under the original question, so anyone can easily see at quick glance the original question and the solution. So marking any post that does not actually contain the solution would kind of defeat the purpose of that.

I have gone ahead and change the posted solution for you.