G Guest Mar 16, 2006 #1 How do I change the default view (to "details", ordered by date modified, most recent date at the top) in Excel 2000? Thank you!
How do I change the default view (to "details", ordered by date modified, most recent date at the top) in Excel 2000? Thank you!
D Dave Peterson Mar 16, 2006 #2 Record a macro when you do data|filter|showall (to show the details). Then continue recording when you sort your data the way you want. Now name that macro Sub Auto_Open() It'll run each time you open the workbook (well, with macros enabled that is). If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm (Ps. Is that what you meant by details?)
Record a macro when you do data|filter|showall (to show the details). Then continue recording when you sort your data the way you want. Now name that macro Sub Auto_Open() It'll run each time you open the workbook (well, with macros enabled that is). If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm (Ps. Is that what you meant by details?)
