Home |
Search |
Today's Posts |
#1
|
|||
|
|||
TEX TO COLUMNS PROTECTED SHEET
I want to protect a sheet, some cells locked some not. I know how to do that
but when the sheet is protected the text to columns is disabled. I need to use text to columns in the unlocked cells. Is there a way to do this? |
#2
|
|||
|
|||
You have a suggestion at your first post.
Jeracho wrote: I want to protect a sheet, some cells locked some not. I know how to do that but when the sheet is protected the text to columns is disabled. I need to use text to columns in the unlocked cells. Is there a way to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
Pivot Table Use When Sheet is Protected | Excel Discussion (Misc queries) | |||
Excel 2002 "Protect Sheet", but allow "Hide Columns"? | Excel Worksheet Functions | |||
Get Msg "Cannot shift objects off sheet" when hidng columns" Why? | Excel Discussion (Misc queries) | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) |