On creating a button to perform a macro, we are hiding columns.
Can the macro pick up that
If the columns E:J are hidden, then the text on the button to read 'Unhide'
If the columns E:J and unhidden, then text on the button to read 'Hide'
I am aware I can change what is written on the button via a macro, but can it see that the columns are hidden????
Make sense I hope
Thanks