the VBA code is on a user form that adds the name to the sheet. th
sheet is never seen by the user.

I have been reading and thinking it might be better to use a vba cod
on the list sheet itself to autosort when the page is open.

I am looking aroung the help pages to see if I can come up wit
anything. no luck yet though. :-

--
Message posted from http://www.ExcelForum.com