TEX TO COLUMNS PROTECTED SHEET

[Guest]

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]

You have a suggestion at your first post.

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?