Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock some of the worksheets in an excel 07 spreadsheet
I have a spread sheet that has five pages. I want my clients to be able to
enter data on the first sheet which will populate the other sheets. I want them to be able to see and print the other four sheets but not enter data in any of them. If possible I would also like them to be able change the size of the cells. Thank you, John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock some of the worksheets in an excel 07 spreadsheet
Use the Protect Sheet function on each sheet that you want protected
selecting the additional options "Format Columns" and "Format Rows" to allow resizing. "John" wrote in message ... I have a spread sheet that has five pages. I want my clients to be able to enter data on the first sheet which will populate the other sheets. I want them to be able to see and print the other four sheets but not enter data in any of them. If possible I would also like them to be able change the size of the cells. Thank you, John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock some of the worksheets in an excel 07 spreadshee
Thank you very much...
"Castell" wrote: Use the Protect Sheet function on each sheet that you want protected selecting the additional options "Format Columns" and "Format Rows" to allow resizing. "John" wrote in message ... I have a spread sheet that has five pages. I want my clients to be able to enter data on the first sheet which will populate the other sheets. I want them to be able to see and print the other four sheets but not enter data in any of them. If possible I would also like them to be able change the size of the cells. Thank you, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock spreadsheet but can sort | Excel Worksheet Functions | |||
lock position of Word object in protected excel spreadsheet | Excel Worksheet Functions | |||
lock position of Word object in protected excel spreadsheet | Excel Discussion (Misc queries) | |||
How can I lock the gridlines in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
how do you lock a jpg on a spreadsheet that you publish to web? | Excel Discussion (Misc queries) |