H
hello
How do I change the default view (to "details", ordered by date modified,
most recent date at the top) in Excel 2000?
Thank you!
most recent date at the top) in Excel 2000?
Thank you!
D
Dave Peterson
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 Aut
pen()
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?)
Then continue recording when you sort your data the way you want.
Now name that macro
Sub Aut
pen()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?)