Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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€ť. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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€ť. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enable Right-click menu | Excel Worksheet Functions | |||
How to enable items on Excel draw menu bar. | Excel Discussion (Misc queries) | |||
Enable the Options button from the Tools Menu | Excel Worksheet Functions | |||
Where is menu option to enable macros? | Excel Discussion (Misc queries) | |||
How do i enable the Query Parameter menu option on the External D. | Excel Discussion (Misc queries) |