I want to hide/unhide as much of the excel interface as possible using VBA (with a toggle button).
What's the hide / unhide VBA for each of these elements .....
> The Top bar (with (X close) and ribbon options
> The Ribbon
> Ribbon Headings (File , Home , Insert ..... )
> The Quick Access Toolbar
> Formula Bar
> Column + Row Headings (A , B , C , 1 , 2 .....)
> Worksheet Labels & Horizontal Scrollbar
> Bottom with Views & the % Magnifier Slider
> Vertical Scrollbar
I realise that it's unlikely that all of them can be hidden.
I have been to hide most of them manually, except for .....
> The Top bar (with (X close) and ribbon options.
> Worksheet Labels & Horizontal Scrollbar.
> Vertical Scrollbar.
Even if I could get to the above state with one click, with 3 elements showing that would be great.