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