How do I lock some of the worksheets in an excel 07 spreadsheet

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
Use the Protect Sheet function on each sheet that you want protected
selecting the additional options "Format Columns" and "Format Rows" to allow
resizing.
 
Thank you very much...

Castell said:
Use the Protect Sheet function on each sheet that you want protected
selecting the additional options "Format Columns" and "Format Rows" to allow
resizing.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking individual cells in an excel spreadsheet 4
Excel Workbook with Multiple worksheets 2
Excel Disallow movement of embedded PDF 2
Spreadsheet usage 1
How to Lock sort on a data entry sheet. 1
push result from one cell to another 2
How do I lock the formatting of my worksheet but still add text? 2
How do I lock ONLY the formatting on an excel sheet? 2

Back
Top