How to enable the Unprotected Worksheet menu

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â€.
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top