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..