Automatically Show/Hide Gridlines And Headlines

Hi there,

On the "Page Layout" of many of the Excel spreadsheets I am assigned is the task to show/hide the gridlines and headings by obviously either ticking or unticking the box next to each of these two options.

As many of the repetitive tasks done through Excels can become time-consuming, this one actually becomes quite painful to repeat each and every time for each Excel workbook/worksheet and so I'd be really grateful to anyone who could develop some sort of Excel add-in (.xlam) which would automate this task by me simply adding a shorcut to it on my Quick Access Toolbar and simply click it to either show or hide the gridlines and headings.

I would guess this requires 2 separate add-ins since one would show the headings and gridlines when clicked and another would hide them.

If you need any more details or if anything wasn't clear enough do not hesitate to let me know, any and all help is greatly appreciated.

Thanks,
Eric

Hi Eric,

Try the attached and see if it doesn't do what you need.

Hi Eric,

What I don't know is if the QAT code will be available when you open old workbooks. Let me know if it works on all of your workbooks.