Blanking of Cells

[Rainer Dalibor]

Hi Newsgroup,

I would like to create a worksheet consisting of two tables.

Table No. 2 holds a database.
Table No. 1 holds the references to this particular database.

The user should be able to work in Table 1, make calculations with the data
of the database but should not be able to read and modify Table No. 2.

Any assistance is highly appreciated.

Thanks in advance

Rainer

 

[Hayeso]

1. Create the database in Sheet1
2. In Sheet2, select the cell that corresponds to the
upper left cell of the database in sheet1 and type =Sheet1!
A1 (Assuming 1st cell of database is in A1).

3. Drag the formula to cover a range the size of the
original database (You may have to work with formatting)

4. Highlight all cells in Sheet2 by clicking in Upper
left corner of sheet.

5. Select Format...Cells...Protection and untick
the "Locked"

6. Select the cells in Sheet2 that hold the reference to
the database

7. Select Format...Cells...Protection and Tick
the "Locked"

8. Protect Sheet2 (Tools..Protection ...Protect Sheet)
9. Hide Sheet1 (Format...Sheet..Hide)
10. Protect the Workbook (Tools..Protection...Protect
Workbook)