Can I lock a set of cells in a worksheet?

Is it possible that a range of cells in a worksheet is protected from
user editing, and the rest of the worksheet is editable as usual ?

Puneet Arora

puneetarora_12's Profile:
View this thread:

7/8/2005 1:51:06 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies

Similar Articles

[PageSpeed] 8

Try this sequence ..

Select the entire sheet first (press CTRL+A)
Click Format > Cells > Protection tab > Uncheck "Locked" > OK

Now select the range of cells to be protected, say B2:B10
Click Format > Cells > Protection tab > Check "Locked" > OK

Then apply sheet protection via:
Click Tools > Protection > Protect Sheet > Password? > OK

Check it out .. Only B2:B10 will be protected
xl 97
GMT+8,  1� 22' N  103� 45' E
xdemechanik <at>yahoo<dot>com
<> wrote in
> Hi,
> Is it possible that a range of cells in a worksheet is protected from
> user editing, and the rest of the worksheet is editable as usual ?
> Puneet Arora
> --
> puneetarora_12
> ------------------------------------------------------------------------
> puneetarora_12's Profile:
> View this thread:

demechanik (4694)
7/8/2005 2:22:29 AM

Works smooooth...

puneetarora_12's Profile:
View this thread:

7/8/2005 8:32:02 PM
"puneetarora_12" wrote:
> :)
> Works smooooth....

Glad to hear that !
xl 97
GMT+8,  1� 22' N  103� 45' E
xdemechanik <at>yahoo<dot>com

demechanik (4694)
7/8/2005 10:07:05 PM

Similar Artilces:

inserting a hard return with replace in a cell
Is there a way to insert a hard return or line break using the replace function in a cell? Thanks brent Use char(10) in your =replace() function. (and remember to turn wraptext on) Brent wrote: > > Is there a way to insert a hard return or line break using the replace > function in a cell? > Thanks > brent -- Dave Peterson Thanks! "Dave Peterson" <> wrote in message > Use char(10) in your =replace() function. > > (and remember to turn wraptext on) > > > > Brent...

Removing characters from cell
Hope someone can help me with this one.... I have text in column "A" a list of parts like the following..... ...nhg1234 ..nhg1235.54 nhg3456 ....nhg1253.7 Is thier anyway of removing the dots in front the part number? I dont want the points moving after the the main part of the number. Please help TiA mag()() Do you part numbers all start with nhg? If yes, you could select column A edit|Replace what: .n with: n replace all And keep hitting the replace all button until all are fixed. "Mag()()" wrote: > > Hope someone can help me with this one.... >...

Can I add a domain to the Blocked Senders list?
I am just getting used to Outlook 2003 and trying to make use of the SP{AM filter. I see that when I right click on a message that one of the options id to add a sender to the "Blocked Senders List" Is there a way that I can also include the option to block a domain? Thanks Dunc Dunc wrote: > Is there a way that I can also include the option to block a domain? There is an easy way, if you're running Outlook 2003+SP1. Dunc wrote: > Is there a way that I can also include the option to block a domain? Right-click on any e-mail, choose (menu) Junk Mail, Junk Mail...

Can I embed a clickable link that includes command line arguments?
I 'm familiar with the process of embedding a clickable link to a file located on a share accessible to the recipient, and do so regularly by using a UNC formatted path: \\ServerName\Path\to the \location\of the\file (Interesting ... the "<" ">" I wrapped the above line in dissappeared as soon as I entered the close bracket. In Outlook [plain text] I'm not used to that happening.) My question: is it possible to do the same thing to launch a .exe (or ..cmd) with command line arguments? Something like: \\UNC Path\Executable /argument1 /a...

How to count cells
Hi, I want to put a summary of Job orders in a table. (Excel (Zip) file attached) I am having a problem of total. I want to make a total of only approved job orders not the all job orders. Also if the column contains hot / cold type, I need red and bold for hot job order of complete row. Also I want to be counted by job type and entity. For example, in the total approved 7 permits, CONST entity 3 cold jobs and 1 hot job. how can i display in the abstract table. Can anyone help me please. +-------------------------------------------------------------------+ |Filename: ...

How can I asign a number value to a text line in Excel?
tI have a Backgammon Club with Internal Club Rankings that are in Text. I want my members to report their wins - 1st, 2nd, and 3rd place - in tournaments to my web site . I would like them to imput: their nickname, date of tournament, tournament Room #, tournament points played for, and host of the tournament. I would further like the calculation to display any change in Ranking as a text cell. Additionally, I want to show for the member, how many more points are needed to get to the next levle and what that (Text)level is. If there is a "what if" for this please advise. Ri...

Locking a Marketing List
I can't find any information about what it means to Lock a marketing list. I've searched the KB, the web, the Help, and the marketing automation training materials, but have not found any references to this and how it's used. What does this mean? Steve, Flagging a Marketing List as "locked" turns off the Manage Members functionality. It prevents you from being able to use the Advanced Find controls for adding, removing and evaluating marketing list members from the marketing list screens as well as selecting records from a list view and adding them to that list. Ho...

Setting a date in the Header
I have a report that I need to print every Friday, but the report is for the following week. So, I want it to say "For the week of: Monday, November 5, 2007." How do I calculate the date to be next Monday? IF you run the report on Friday (and never on any other day), -- Add a control to the report -- Set its source to = "For the week of " & Format(DateAdd("d",3,Date()), "Long Date") If you run the report on any other day of the week this will fail. So you might want to use = "For the week of " & Format(DateAdd("d&...

Hiding Settings section in left menubar
Hi all, I can't hide the Settings area in left menubar. I want to hide it for all users except system administrator. In security roles doesn't appear the option. I'm doing something wrong? Thanks to all in advance. One idea is that If you use the outlook version of CRM your users will not see the Settings. It automatically diappears. The settings tab only shows up in the Web Version --------------------------- Pierre Hulsebus - CRM Consultant Certified Integration Between Microsoft CRM to Microsoft Solomon --------------------------...

users can't login on one PC
I have 1 PC that was just upgraded to GP 10 SP 2 and now only the SA can login. When a regular user account tries to login they get the error: "The login failed. Attempt to login again or contact your system administrator" That same id is able to login on every other PC so I know it is not SQL DB security and the SA can login from this PC so i am pretty sure it is not the ODBC. Any help would be appreciated. Fliehigh OK So I figured it out this DSN was setup using the IP address of the SQl server and the rest where using the DNS name. I changed it and it worked great. Fli...

Control can't be edited; it's bound to a replication system column 'TableName'.
I have an Access 2007 accdb database. It hast a table in it with field names TableName and FieldName and a bunch of others. This table has had a small number of records added to it (37) over the life of the database. Suddenly, the two fields TableName and FieldName cannot be edited. That is even if the table is open as a table and you try to type a new record. When you do that an error message is briefly displayed in the left hand end of the Access main window's status bar. For example if you try to input anything into the TableName field you will be blocked and you will briefl...

Can't download bank statement to Money
I've not had this problem until today. No bank data is getting downloaded to MONEY and I don't know if it's the program issue or if there is any virus going on to affect this. Thanks for your help. Without more information from you, I can only tell you that I've not had any problems downloading bank data. Some useful information would be the bank you are using, the version of Money, and the error you are receiving. If you don't get an error, you may not have any transactions to download at this time. "Hannah" <> wr...

Unpopulated Cell Address
Hi I'm a newbie and was wondering can anyone help with my query. I am trying to find out how to print a spreadsheet with just the data that is contained in certain cell address's. Where a cell address is not populated I want the whole row to not appear in a printed copy. Any ideas? Try this idea Sub hiderowsandprint() With Range("a1:a21") .SpecialCells(xlCellTypeBlanks).Rows.Hidden = True .Resize(21, 8).PrintPreview .Rows.Hidden = False End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Mick Smith" <notsa...

Preventing Column Cell Values from Printing
I have a summary worksheet with several columns of information. There is one particular column (E25:F39) where I don't always want to print the values. Is there some simple way to toggle this column's values on and off just before hitting the print command? I was thinking of using an adjacent tick box outside the print area, which when ticked would print the column values, and vice-versa. I'm looking for a formula that would examine the tick box, and if the tick (letter 'a' in Marlett font) is not present (i.e. cell value = ""), then the values in column (E25:...

change the formula by changing contents of cell
I have a table that ranks a list of players by their statistics, for example, when I change cell B2 to "walks", my formula (large) lists the player with the most walks in cell B4, 2nd most in B5, 3rd in B6... that works well because more walks are good. But, when I change cell B2 to "strikeouts" I want it to list the player with the fewest number of strikeouts in B4, next fewest in B5 and so on. Is there a way to change the "large" function to the "small" function within the formula? I have set up a helper cell (C2) that changes fro...

How do I change the value in cell based on a future date
I would like certain cells to be cleared after a certain date one way: Put this in the ThisWorkbook code module (Right-click the workbook title bar and choose View Code): Public Sub Workbook_Open() If Date > #12/15/2004# Then _ Sheets("Sheet1").Range("A1,B2,J10,K39").ClearContents End Sub Note that this won't work if the user opens your workbook with macros disabled. Note also that there's no way to prevent a user from accessing your data - i.e., they can set their clock back and open the file. You can make things more difficu...

IF COUNTIF & COUNTA on Filtered Visible Cells #7
Hi Frank, Hope this will help. Correction to Last Posting: My Helper Column "U" increments one Row at a time and says: Check from Row above Current Row back to beginning of my "V" Range: i the Room was used previously give me the Last (MAX) time it was used b returning the relevant Row Number of the (text based) Group Nam (Executive, Trainees, Manager, Graphics, etc.) that used the Room Last The Helper Column "U" then passes this data to the Formula in Colum "T" - it checks for the criteria within the specified Range and doe the COUNT calculation us...

Data within a cell
If names are in cells as "last name, first name, middle initial" can a macro be run to change the order to "first name, middle initial, last name"? A formula will do Assuming you have spaces between commas and names, =MID(A2,FIND(",",A2)+2,FIND(",",A2,FIND(",",A2)))&RIGHT(A2,FIND(",",A2,FIND(",",A2)))&", "&LEFT(A2,FIND(",",A2)-1) Then just copy down. If you want this more permanent, copy the cells with formulas, right click, paste special. -- Best Regards, Luke M *Remember to click &q...

Transfering a changing cell value progressively through a workbook
I am creating a payment application form in excel 2007 using windows 7. Each worksheet represents one months invoice. Say I have a formula in "sheet 1/ cell Q7" that sums the total billed to date for a particular budget line item. This value will be transfered to a the next months payment application "sheet 2/ cell K7" this becomes the total amount of previous applications, then "sheet 2/ Q7 is =sum(K7,M7,O7) this value is transfered to "sheet 3/ K7, and so on and so on, until the completion of the job. How do I acomplish this. -- Thanks Mike ...

Data entered from list automatically enters number in another cell
I am using Excel 2007 and here is an simplified example of what I need. Items Price Potatoes 4.35 Apples 5.55 Oranges 7.95 Onions 4.55 Carrots 3.75 Items Column is List for Valid entries in table below Prices are the numbers I want entered when I enter the Item If I enter Oranges from Dropdown List in A16 , I want Excel to automatically enter the number 7.95 3 columns over in D16,or if it is quite a bit easier, just 1 column over in cell B16 Example of table I want: My Entries: Excel Enters ...

Can't delete a personal folder
Hello. My problem is that I somehow ended up with an extra personal folder and I simply can't delete it. I've tried moving the .PST file and creating a different one. No luck. I've even uninstalled outlook 2000 three times to no avail. After I uninstalled it I looked in "My Documents and Settings" where Outlook and other applications leave data behind and I deleted everything that I found but that didn't work either. I reinstalled Outlook 2000 and there was my Personal Folder again! When I click on the properties and I try to close it it says "Ob...

Printing 2 worksheets to a 2 sided document
Is there any way to print - front to back - 2 seperate worksheets? Turn the paper over and print the second worksheet???? Maybe you can create a worksheet with a picture of both ranges on it: Insert a new worksheet Edit|copy the first range shift-Edit|Paste Picture Link (on that new worksheet) Back for the second range and shift-edit|Paste picture link (right near your first pasted picture link). (insert a nice page break, too) And by pasting a link, you can change the original range and your picture will update right away. (Keep that worksheet as long as you want and print from there???)...

Set-Acl very slow?
I put together a script that uses the SET-ACL cmdlet to apply file system permissions to directories listed in an input file. The script seems to work fine, but is extremely slow if the directory contains large number of folders\files. I put together a batch script that utilizes XCACLS.vbs which runs a lot faster. I'm wondering why the powershell script is running slower. Does anyone have any ideas? Xcacls script completed in 10 minutes. Powershell script was still processing after 18 hours. Both scripts were configured to modify the same directories. Both scrip...

Can't open some mail after upgrade
Hello.. We upgraded our server to Exchange 2003. After the upgrade our clients using Windows 2000 and Outlook 2000 do not seem to be able to open mail that has been forwarded more than once and contains attachments. I can forward the same piece of mail to someone using an Outlook 2003 client and they can open it, but the client using Outlook 2000 cannot view the mail, preview the mail, forward the mail or even see or save the attacment. The error is: "Can't open this item. Could not complet the operation because the service provider does not support it." Any help...

Switch format characteristics cell-by-cell?
I want to do something like this: IIf([table_a].addr1 <> [tableb].addr1, SwitchToBold([tablea].addr1), [tablea].addr1) Is there such a function or set of functions, e.g. switch to italics or change the font entirely? I can't find it and am not entirely sure where to look. Thanks in advance. On Thu, 30 Aug 2007 11:30:14 -0700, Jonathan Ball <> wrote: >I want to do something like this: > >IIf([table_a].addr1 <> [tableb].addr1, SwitchToBold([tablea].addr1), >[tablea].addr1) > >Is there such a function or set of functions, e.g. swit...