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

Similar Threads

Enable Iterative Calculations 0
VBA for Dependents shortcut menu 0
Need Help with Macro Security 1
Insert Menu Greyed Out 0
VBA to do a mailmerge from a Specific Excel worksheet 0
inserting a picture into unprotected cells in a protected excelworksheet 0
Delete unprotected cells in protected worksheet 1
Copying in sheet with protection with the use of a macro 5

Top