Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default unprotect specfic cells in worksheet


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default unprotect specfic cells in worksheet

Hi,

With protection off, select the cells you want to unprotect and then choose
the command Format, Cells, Protection tab, and uncheck Locked. Then
reprotect the sheet.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"ND at sib" <ND at wrote in message
...

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default unprotect specfic cells in worksheet

Select your specific cells. Choose Format/Cells/Protection, uncheck the
Locked checkbox.

In article ,
ND at sib <ND at wrote:
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default unprotect specfic cells in worksheet


Select the cell(s), press Ctrl-1 to access the Format properties, select
*Protection* and uncheck the "locked" box.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45160

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
Unprotect cells in a worksheet when I have forgotten the password Gee Excel Discussion (Misc queries) 3 March 14th 13 10:42 AM
Pivot Table - Total Specfic Columns jeremiahb Charts and Charting in Excel 3 December 2nd 08 02:13 PM
Unprotect a range of cells in a protected worksheet N.B.Pitkar Excel Discussion (Misc queries) 1 October 1st 07 05:21 AM
Unprotect Worksheet. xoom3 Excel Discussion (Misc queries) 4 July 14th 06 10:00 PM
insert picture to a specfic range of cells CORY Excel Discussion (Misc queries) 8 February 3rd 06 05:50 PM


All times are GMT +1. The time now is 01:14 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"