Custom Option in Data Validation List

Gday Everyone,

Is it possible to have a custom made selection in a data validation list?

the code i am using to generate and assign my current list is

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

This Hides and shows named ranges on worksheet 30-04-2012 depending on the value the user selects on WS 'Main'.

How would i add the option to the list such as "Show All" which would automatically unhide all rows between 3:1000 ?

Regards

hi jordan2322, please check attachment

watersev thank you - exactly what i was after!