Thank you very much for your help, Debra.
| You can use Custom Views to store the settings:
|
| Filter the table
| Choose ViewCustom Views
| Click the Add button
| Type a name for the custom view
| Make sure that 'hidden rows, columns and filter settings' has a check mark
| Click OK
|
| To show a saved custom view, choose ViewCustom Views
| Select a view, click Show
--
| Debra Dalgleish
| Excel FAQ, Tips & Book List
|
http://www.contextures.com/tiptech.html
|