View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paresh Paresh is offline
external usenet poster
 
Posts: 2
Default 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