LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jack
 
Posts: n/a
Default How to protect a cell or rows with MS excel 2000

Hello,
Lets say for example I have a formula in row a1 and column a1 and some text
in a1 and d1.
What I would like to know how would I protected which I mean if I let others
use my spreadsheet I want to not let people change any info in that
individual cells. I read that I could use a 0 for unlock and a one to lock
but I am not sure how to do this. Can someone show me the steps to make this
work.
Thanks for your help


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
In excel how do I protect the format of a cell but let the user c. John Louis Excel Discussion (Misc queries) 11 October 1st 07 12:03 AM
IN EXCEL 2000, HOW DO I PROTECT MULTIPLE WORKSHEET ME Excel Worksheet Functions 2 January 7th 05 04:22 PM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"