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
|