Hi

I have created a shared workbook, protect 5 individual sheets in the
workbook and allow some users to update sales data only while protect
formulas. I have also assigned a routing recipient function to the workbook,
then it finally comes back to me after all of updates. However I can not
unprotect sheets and this workbook any more, because the unprotect functions
for the sheets and workbook just dimmed out, urgent help! many thanks...

Try copying the data (click into the square between the column letters and
row numbers) and paste it into a new workbook.

"template-just like "stationery" function" wrote:

Hi

I have created a shared workbook, protect 5 individual sheets in the
workbook and allow some users to update sales data only while protect
formulas. I have also assigned a routing recipient function to the workbook,
then it finally comes back to me after all of updates. However I can not
unprotect sheets and this workbook any more, because the unprotect functions
for the sheets and workbook just dimmed out, urgent help! many thanks...