I want to make parts of my worksheet unavailable to users so that they can not click in the cell, change formats of the cell(s), etc..

Excel Help tells me that the only way to do this is if I am SHARING the workbook but this is not that kind of thing. It’s not on a network and it’s not a multi-user workbook.

How do I protect (for example) A1:A10 yet leave everything around it open for data-entry?

PS: I am working with Excel 2007, but I also need this information for my 2003 files that I use on another computer as well.

Any help would be appreciated!!

.

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

This isn’t really much of a problem or issue, But I ‘m having some difficulty about thinking how I would come around this problem.
I ‘m using Microsoft Access (Yea the Database software) for some course work that I will be starting on soon.
Anyway, this database will be used in a business once it has been created. It will have a table for employees details, and also a table for events. Each event has a name and a number regarding the space / amount of people that can attend the event.
In the data entry screen for each employee, there is a drop down box which contains the list of events from the table "Events" using a Lookup wizard. I can now write employees details and choose an event for them to attend. However I want a function that also does something along the lines of this;
Once an event has been chosen for an employee, the system looks up the "space avaliable field" from the other table "Events" It will then compare the number of times I have used that Event for employees and Perform a subtraction (Like the one shown below) leaving the answer in a label or text box shown in the employee data entry screen. Just so I can see if there is space avaliable before i assign then to an event.
Space avaliable value – COUNT(How many times each event has been used)

I know Microsoft Access can be programmed in VB, but I wondered if it was possible to get around this before starting to get envolved in coding. Anyone got any ideas?

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I want to make parts of my worksheet unavailable to users so that they can not click in the cell, change formats of the cell(s), etc..

Excel Help tells me that the only way to do this is if I am SHARING the workbook but this is not that kind of thing. It’s not on a network and it’s not a multi-user workbook.

How do I protect (for example) A1:A10 yet leave everything around it open for data-entry?

PS: I am working with Excel 2007, but I also need this information for my 2003 files that I use on another computer as well.

Any help would be appreciated!!

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I want to protect cells from other users possibly changing the format (such as date) but allow them to enter data in the cell.
I wasnt to allow other users to change/put down data, change width of columns/rows/save, etc but restrict them from changing the format. Example: I want the date format as DD MMM YYYY,
Problem is when I unlock then password protect it still allows me to change format while the other cells that were locked prior to password protection pops a message how it i read-only (not allowing any modification/data entry.

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software