View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod
 
Posts: n/a
Default locking template?

Hi grylion,

Use Format|Cells|Protection and unlock the cells you want to be able to
enter data into, then use Tools|Protection|Protect Sheet or Protect Workbook
to apply the level of protection you want - the options are explained in
Excel's help file, under 'Protect workbooks and worksheets from changes'.

Cheers

--
macropod
[MVP - Microsoft Word]


"grylion" wrote in message
...
Hi All,
I have created a simple template for my duty rosta.
I can add hours etc and they total up ok.

I want to "lock" the template so that only the data can be changed, not

the
cell size/fonts etc.
I have searched around but cannot find any refence to it.
Hoping someone can advise me
Thanks Peter