How to enable the Unprotected Worksheet menu

  • Thread starter Thread starter xx
  • Start date Start date
X

xx

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â€.
 
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
 
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
 
Back
Top