Prev: My places Bar
Next: Issue with being able to select 64 bit Data Sources in Excel 2007
From: VIPone on 14 Jan 2010 13:45
Can you protect a sheet and workbook so that rows, columns and formulas
cannot be changed, but others can add data (filling cells with data), but
still have users with an older version of Excel be able to access them?
From: trip_to_tokyo on 14 Jan 2010 13:50
Yes, you can protect individual cells within a Worksheet whilst leaving other
cells within the same Worksheet open for amendment.

If my comments have helped please hit Yes.

Thanks.

"VIPone" wrote:

> Can you protect a sheet and workbook so that rows, columns and formulas
> cannot be changed, but others can add data (filling cells with data), but
> still have users with an older version of Excel be able to access them?
From: Eduardo on 14 Jan 2010 13:51
Hi,
Highlight the cells you want to let users enter information, right click on
the mouse,
format cells, Protection, uncheck Locked, then protect the worksheet

if this helps please click yes thanks

"VIPone" wrote:

> Can you protect a sheet and workbook so that rows, columns and formulas
> cannot be changed, but others can add data (filling cells with data), but
> still have users with an older version of Excel be able to access them?
 | 
Pages: 1
Prev: My places Bar
Next: Issue with being able to select 64 bit Data Sources in Excel 2007