As you are awake Irene

[doug]

I've set up a spread sheet for a friend's rent payment - she's been having bother with her Landlord. I'm going to give her a copy to use on her PC. The print out she had yesterday was enough to put her Landlord in his place. What I'm trying to do is to protect a couple of ranges so that all that can be entered are the actual dates and payments. I can protect the whole shett but cannot unprotect selected cells. I can't find a way of protecting only selected cells. I used to be able to do this sort of thing way back but I've gone rusty. Don't go back to bed yet.

[Irene]

I just copied & pasted this help from my Excel.......

Password protect a worksheet or workbook

Protect worksheet elements

Protect worksheet elements from all users

Switch to the worksheet you want to protect.

Unlock any cells you want users to be able to change: select each cell or range, click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.

Hide any formulas that you don't want to be visible: select the cells with the formulas, click Cells on the Format menu, click the Protection tab, and then select the Hidden check box.

Unlock any graphic objects you want users to be able to change.

How?

You don't need to unlock buttons or controls for users to be able to click and use them. You can unlock embedded charts, text boxes, and other objects created with the drawing tools that you want users to be able to modify. To see which elements on a worksheet are graphic objects, click Go To on the Edit menu, click Special, and then click Objects.

Hold down CTRL and click each object that you want to unlock.

On the Format menu, click the command for the object you selected: AutoShape, Object, Text Box, Picture, Control, or WordArt.

Click the Protection tab.

Clear the Locked check box, and if present, clear the Lock text check box.

On the Tools menu, point to Protection, and then click Protect Sheet.

Type a password for the sheet.

Note The password is optional; however, if you don't supply a password, any user will be able to unprotect the sheet and change the protected elements. Make sure you choose a password you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet.

In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.

Click OK, and if prompted retype the password.

Give specific users access to protected ranges

You must have Windows 2000 to give specific users access to ranges.

On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges. (This command is available only when the worksheet is not protected.)

Click New.

In the Title box, type a title for the range you're granting access to.

In the Refers to cells box, type an equal sign (=), and then type a reference or select the range.

In the Range password box, type a password to access the range.

The password is optional; if you don't supply a password, any user will be able to edit the cells.

Click Permissions, and then click Add.

Locate and select the users to whom you want to grant access. If you want to select multiple users, hold down CTRL while you click the names.

Click OK twice, and if prompted retype the password.

Repeat the previous steps for each range for which you're granting access.

To retain a separate record of the ranges and users, select the Paste permissions information into a new workbook check box in the Allow Users to Edit Ranges dialog box.

Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges dialog box.

In the Protect Sheet dialog box, make sure the Protect worksheet and contents of locked cells check box is selected, type a password for the worksheet, click OK, and retype the password to confirm.

Note A sheet password is required to prevent other users from being able to edit your designated ranges. Make sure you choose a password you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet.

Protect workbook elements and files

Protect workbook elements

On the Tools menu, point to Protection, and then click Protect Workbook.

Do one or more of the following:

To protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted, select the Structure check box.

To protect windows so that they are the same size and position each time the workbook is opened, select the Windows check box.

To prevent others from removing workbook protection, type a password, click OK, and then retype the password to confirm it.

Protect a shared workbook

If the workbook is already shared, and you want to assign a password to protect the sharing, unshare the workbook.

How?

Have all other users save and close the shared workbook. If other users are editing, they will lose any unsaved work.

Unsharing the workbook deletes the change history. If you want to keep a copy of this information, print out the History worksheet or copy it to another workbook.

How?

On the Tools menu, point to Track Changes, and then click Highlight Changes.

In the When box, click All.

Clear the Who and Where check boxes.

Select the List changes on a new sheet check box, and then click OK.

Do one or more of the following:

To print the History worksheet, click Print .

To copy the history to another workbook, select the cells you want to copy, click Copy , switch to another workbook, click where you want the copy to go, and click Paste .

Note You may also want to save or print the current version of the workbook, because this history might not apply to later versions. For example, cell locations, including row numbers, in the copied history may no longer be current.

On the Tools menu, click Share Workbook, and then click the Editing tab.

Make sure that you are the only person listed in the Who has this workbook open now box.

Clear the Allow changes by more than one user at the same time check box.

If this check box is not available, you must unprotect the workbook before clearing the check box.

How?

Click OK, point to Protection on the Tools menu, and then click Unprotect Shared Workbook.

Enter the password if prompted, and then click OK.

On the Tools menu, click Share Workbook, and then click the Editing tab.

When prompted about the effects on other users, click Yes.

Set other types of protection if you want: Give specific users access to ranges, protect worksheets, protect workbook elements, and set passwords for viewing and editing.

On the Tools menu, point to Protection, and then click Protect Shared Workbook or Protect and Share Workbook.

Select the Sharing with track changes check box.

If you want to require other users to supply a password to turn off the change history or remove the workbook from shared use, type the password in the Password box, and then retype the password when prompted.

If prompted, save the workbook.

Protect a workbook file from viewing or editing

On the File menu, click Save As.

On the Tools menu, click General Options.

Do either or both of the following:

If you want users to enter a password before they can view the workbook, type a password in the Password to open box, and then click OK.

If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box, and then click OK.

When prompted, retype your passwords to confirm them.

Click Save.

If prompted, click Yes to replace the existing workbook.

Hope this is what you are looking for. :D

Sorry it's such a big post!!

[doug]

Thank you Irene. After mucho struggling managed to do what I wanted to do. I grew up on Visicalc (After Fortran of course). then I had a play with Visicalc on My home built ZX81 (remember the root 2 problem well I had that as well as an incorrect PCB layout, so the clock signal became notclock. Got round that by fiddling the leg configuration of the clock circuit transistor driver - I did have one of the very earliest models having pre-booked it prior to delivery) Then I went on to Lotus 123, which I took to very easily. the company dictat said "oh no don't we're going Microsoft". Well circumvented that by locking up my Co. PC until the IT department came and physically dropping my PC onto the floor and replacing it with one configured the way they wanted. Drove me nuts for a couple of years because I didn't find the Microsoft spreadsheet to be intuitive the way I found with the Lotus version. The bulk of my work was Physical/Chemical/Mathematically biased to production Chemical engineering applications. So I struggled and cheated. Got a PC for home and configured it the way that enabled me to solve the basics of my problems the spent wasted hours at work producing "correct" versions of the output to satisfy the PC brigade. Am struggling with Excel to this day. I know what can be done but I struggle to think in reverse, in my opinion, for Microsoft. Although I'm fairly competent in the scientific field OOOh I do envy the present generation that don't have to remember conversions etc. They are now brought up with the consistent approach. No foot-poundals or psi for them!

You can go to bed now.

[Irene]

You can go to bed now.

doug, I know exactly what it feels like to be force-fed Windows.

My early computer experiences were on DOS based packages. including SuperCalc. When the establishment where I worked decided that the new 'level playing field' would be through 'Windows', I was given a single half day introduction each to Windows, Word and Excel. Then we were still expected to achieve the same deadlines as before!!

Naturally, I struggled in the begining, but there's nothing like being thrown in at the deep end to make you swim. Other packages like PowerPoint, Access etc., it was a case of just pick up the baton and run.

However, as you can see, I am up and about once more. :D

My usual practice is to go to bed around 9pm, read for a while (anything from one paragraph up!). Consequently, I am awake early. So I am usually on the forum from around 7am on and off through the day. :D

[doug]

It was a great new world in those days - God an I getting old