Locking down an Excel Spreadsheet 1

[Savil]

Hi All
I am not too familiar with excel and need some help in locking down a spreadsheet. The spreadsheet is imported into access but the users are constantly editing the spreadsheet which is doing my head in. All I want the users to be able to do is

Add rows
Edit rows

I dont want them to be able to do anything else ie change colum names, mess around with cell borders, add new columns etc

Thanks in advance

 

[questionmark1]

Hi Savil,

as far as I know excel does not allow you to protect the sheet and in the same time to give the users the permission to insert columns.

The best is, to unprotect the cells which you want to be edited (select range of editable cells, then go to Menue: Format --> Cells --> Register: protection, deactivate the check box "Locked").

Then you can protect the sheet by selecting menue: Tools --> Protection --> Protect Sheet

Now only those cells are editable which were unprotected by you.

Instead of giving the users the permission to insert rows, I suggest that you insert enough cells in advance.

Hope this will help you! Kind regards, Questionmark1

 

[Savil]

Thanks Questionmark1 at least I now have a stating point.

 

[KenWright]

From XP onwards Tools / Protection / Protect Sheet will give you the option of allowing users to add/delete rows/columns based on you choosing those options when presented with the list.

Regards
Ken........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[firefytr]

Also, in Excel 2003, you can set users permissions to a pre-defined range.

-----------
Regards,
Zack Barresse