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?

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