Locking cells in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm designing an analysed cash book for a friend. I want to protect the headings but allow free access to the remaining cells for data entry and inserting formula eg page totals. When I protect the sheet and lock the headings cells itworks fine except that the formula button won't then work so my friend won't be able to total his data at the end. Any ideas?
 
I do this quite often and do not have any problems. Be
sure all the cells that will have access by the client are
unlocked.

Charlie O'Neill
-----Original Message-----
I'm designing an analysed cash book for a friend. I want
Click to expand...
to protect the headings but allow free access to the
remaining cells for data entry and inserting formula eg
page totals. When I protect the sheet and lock the
headings cells itworks fine except that the formula button
won't then work so my friend won't be able to total his
data at the end. Any ideas?
 
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

Excel 95 (sorry) 7
copy cells but lock editing 5
How do I lock certain cells in excel 2007? 1
MS Excel 2003 - Autofilter for protected cells 1
Locked worksheet & hyperlinks (w/ select locked cells unchecked) 1
Cell Protection Query 15
Lock specific cell 1
Locked cells in Excel 1

Back
Top