Protection in Office 2003 Excel

[shan808]

I am new to 2003 Excel.

Is there a function same as 2000 Excel's Protection of 'Objects'.

I have tried the protection function in 2003 Excel and untick 'objects',
however, it protect the whole worksheet and I cannot input data nor format
cell.

Pls help !

 

[Gord Dibben]

By default all cells in a worksheet are locked when sheet protection is
enabled.

It is up to you to decide which are to be locked or unlocked when the sheet
is protected.

Format>Cells>Protection is where you would change the "locked" or "unlocked"
status.

Select all cells and unlock them.

Select the cells to be locked and lock them

Then Tools>Protect>Protect Sheet.

Note the selectable options under "allow users to" when protecting.


Gord Dibben MS Excel MVP