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...
 
Back
Top