How to hide pre-defined columns at the touch of a button
Scenario:
I have multiple spreadsheets which have predefined columns (i.e. Product, Price, Quantity, Total)
I wish to be able to hide predefined columns (i.e. Product and Total)
Ideally it should be in the form of a macro with a button on the toolbar (or an added menu item) so that I can apply it to spreadsheets which I load
Any ideas would be greatly appreciated
|