"Holt88" <Holt88@discussions.microsoft.com> wrote in message
news:21EDB50B-ADED-4C71-BAFC-ECAA79216818@microsoft.com...
> 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.


By default, all cells are locked. It doesn't really take effect until you
protect the sheet (Menu: Tools, Protection, Protect Sheet). To do what
you're asking, simply select the cells you want UNlocked, click Format,
Cells, Protection, and UNcheck the Locked option.

As far as mousing over vs tabs, I'm not clear what you mean by "only be able
to mouse over them". Unless there's a compelling reason to do otherwise,
it's ALWAYS a good idea to give users two ways to navigate and enter data,
especially since the keyboard's more efficient.