Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeracho
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilter in protected sheet Javier Excel Worksheet Functions 5 March 24th 08 05:56 PM
Pivot Table Use When Sheet is Protected ExcelMonkey Excel Discussion (Misc queries) 1 August 19th 05 12:10 AM
Excel 2002 "Protect Sheet", but allow "Hide Columns"? VP Safe Excel Worksheet Functions 2 July 5th 05 07:13 PM
Get Msg "Cannot shift objects off sheet" when hidng columns" Why? Steve Ball Excel Discussion (Misc queries) 2 June 27th 05 06:41 PM
refresh external data on a protected sheet ajf Excel Discussion (Misc queries) 0 March 11th 05 09:01 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"