Hello,
I am looking to find a piece of code to go into my macro that will effectively replace me selecting all, then going to the ribbon > DATA > OUTLINE > Hide Detail
Is it possible to do this? I have tried recording macro, but it does not register it.
What I do is, go into the excel, refresh linkss, auto refit all coloumns, and then i need to select all and hide detail. Its pretty basic so far:
Sheets("Month").Select
Cells.Select
Cells.EntireColumn.AutoFit
Cells.EntireRow.AutoFit
And i just want to be able to select all cells, and hide detail.
Is it possible?If so, any help would be nice.
Thanks In advance..
Bookmarks