Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Anat
 
Posts: n/a
Default Cell protection with hidden columns

Is there a way to view hidden columns when the cells in those columns are
protected?

Thanks,
Anat
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Cell protection with hidden columns

You could unprotect the worksheet.
Visit JE McGimpsey's site:
http://mcgimpsey.com/excel/removepwords.html

Or you could toggle a setting.

Tools|Options|transition tab|check transition navigation keys.

Then find an unlocked cell and type = (just an equal sign)
Then use the mouse (or arrow keys) to drag through the hidden column range.

That unlocked cell could be on any worksheet if you don't have unlocked cells
available.

Anat wrote:

Is there a way to view hidden columns when the cells in those columns are
protected?

Thanks,
Anat


--

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
Conditional Cell protection Bultgren Excel Discussion (Misc queries) 0 November 8th 05 11:50 AM
Determine if another cell is hidden in a Formula JWhales Excel Discussion (Misc queries) 0 July 27th 05 03:25 AM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
Hidden Columns are unhidden when inserting a Formula Andy Excel Discussion (Misc queries) 0 April 4th 05 08:16 PM
Cell Colors and Sheet Protection cincode5 Excel Discussion (Misc queries) 1 December 3rd 04 10:39 PM


All times are GMT +1. The time now is 01:39 PM.

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"