| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating Spreadsheets for others to fill in
I am creating a spreadsheet for other people to fill in on a daily basis. Am
I able to "anchor" a formula so that no one can accidentally delete it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating Spreadsheets for others to fill in
look under help for "Allow cells to be edited in a protected worksheet"
"cmerci01" wrote in message ... I am creating a spreadsheet for other people to fill in on a daily basis. Am I able to "anchor" a formula so that no one can accidentally delete it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating Spreadsheets for others to fill in
you can also look into what a "template" is and how it works once you have
that spreadhseet layout and formulas with the protection. "cmerci01" wrote in message ... I am creating a spreadsheet for other people to fill in on a daily basis. Am I able to "anchor" a formula so that no one can accidentally delete it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Dynamic Spreadsheets | Excel Discussion (Misc queries) | |||
| Creating a macro for all future spreadsheets | Excel Discussion (Misc queries) | |||
| creating a looping formula between different spreadsheets | New Users to Excel | |||
| Creating a link between cells in two different spreadsheets | Excel Discussion (Misc queries) | |||
| creating spreadsheets and workbooks | New Users to Excel | |||
Linear Mode
