LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to protect single cell or cells range from being over-written?

Hi,

I have finished a worksheet and pass it to my users, there are some fix
information stored in the some cells, which I don't want user to change,
and other cells are for user key in the data to be calculated...

Kindly pls tell me how to protect single cell or cells range instead of the
whole worksheet from being over-written?

Thanks
Michael




 
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
How do you password protect a single cell or column of cells Kinnaird New Users to Excel 3 June 19th 12 06:33 PM
subtract a single cell from range of cells and then count tworrall Excel Worksheet Functions 8 October 16th 09 01:45 PM
how do I protect a single cell JimK Excel Discussion (Misc queries) 2 November 11th 08 10:16 PM
How do I protect one single cell? Neil Grafton New Users to Excel 3 July 5th 08 09:29 PM
How to I copy text from a range of cells to another single cell? WRT Excel Discussion (Misc queries) 2 December 18th 05 06:17 AM


All times are GMT +1. The time now is 06:51 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"