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

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

Hi Alphonse,

So far as I know, the suggestion from Tom will help you a lot on this issue. Please feel free to let me know if you have any further questions.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Thank you both.
To do that I would need to include the password in the macro and then the
user would have access to it. Is there some way to store the password so
that the macro has access to it, but not the user?

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us


"Wei-Dong Xu [MSFT]" wrote in message
...
Hi Alphonse,

So far as I know, the suggestion from Tom will help you a lot on this
issue. Please feel free to let me know if you have any further questions.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.