How to enable the Unprotected Worksheet menu
 

1) In Excel, I protected the worksheet and sheet. Then clicked Shared
Workbook and Shared Workplace. After that, when I unprotect the file, the
drop down menu in Tools for unprotection is all off. Please help.

2) In Excel, how can I reverse the result to split the value from
€œConcatenate€�.

How to enable the Unprotected Worksheet menu
 

Hi,
To your first question once you unprotect the file your drop down list for
unprotection will be off, your protect sheet will be on
To the 2nd question, you have to work around, first copy and paste the
concatenate column as Value, then do a text to column
Hope this helped

"xx" wrote:

1) In Excel, I protected the worksheet and sheet. Then clicked Shared
Workbook and Shared Workplace. After that, when I unprotect the file, the
drop down menu in Tools for unprotection is all off. Please help.

2) In Excel, how can I reverse the result to split the value from
€œConcatenate€�.