View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default make spreadsheet look professional

Use Protection

Begin by unprotecting the worksheet and workbook and unlocking all the
cells. Then lock the cells with the formula. Then protect the worksheet.
--
Gary''s Student - gsnu200832


"willem" wrote:

In particular I have calculations for channel flows, the user can fill out
certain values and it returns it's capacity of the channel. I wonder if it
was possible to block calculation cells and only make the input cells
accesible for the user. How should i do this?

W

"Gary''s Student" wrote:

This is a metter of individual sytle. I would begine by looking at some
template to see what you like and adapt them:

http://office.microsoft.com/en-us/te...595491033.aspx
--
Gary''s Student - gsnu200832


"willem" wrote:

I want a certain spreadsheet to look good.
Block the whole layout and only allow users to fill out certain cells.
What is the most simple way to do so?