Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking template?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking template?
Thanks very much for your promt reply.
regards peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
=IF problem | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) |