Protection in Office 2003 Excel

  • Thread starter Thread starter shan808
  • Start date Start date
S

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 !
 
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
 
Back
Top