View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Defining specific areas for users to enter data

Read about Protection in Help
Select the 'hot' cells; use Format |Cells; open Protection tab and uncheck
the Locked box
Use Tools | Protection - Worksheet to protect the worksheet
Done!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Holt88" wrote in message
...
I'm looking to have specific cells where users can enter information,
which
is linked to other calculations in the sheet. I want everything else
protected except for those few cells ("hot") and would like the user to
only
be able to mouse over them. I've also heard it is possible to "tab"
between
these "hot" cells, enabling a user to quickly fill out a template. Any
ideas?
Thanks in advance.