You could always provide your own interface that fires a macro to get
preferences, unprotect the sheet, do the sort, then reprotect the sheet.

--
Regards,
Tom Ogilvy

"Alphonse Giambrone" wrote in message
...
I am generating an Excel 2K workbook from an Access application and using
automation to add formatting, data validation, etc and then turning on
protection for the sheet so the recipient can only change/add to certain
columns.
Client now wants to allow the recipient to sort the data and hide columns
of
their choosing.
With protection turned on, these fumctions are not available.
Is there any way to allow sorting and hiding columns in a protected sheet.

Thanks,

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us