that won't work as i want to send the worksheet out to a large audience. the
data needs to be protected, but want to let the audience sort the data
according to their needs. don't want them to change the data; just be able to
sort.
--
/clm


"Robnific" wrote:

Piece of Cake
open the page :
unprotect all
sort whatever you like
protect
show page
or
only protect page when you jump to another sheet.

Only need basic VBE code :)

www.allocator.nl
Home of James 2007