Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Protecting value in cells to change

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Reijer - 25 Nov 2006 20:04 GMT
Hello Excellers,

I have the next problem, when i have a value on Sheet1!C3, Sheet2!cells
C3:C10 may not bechanged. When sheet1!C3 is empty, Sheet2!cellsC3:C10 can be
changed. How can i accomplish this action ?

Greetz,
Reijer
T. Valko - 25 Nov 2006 22:21 GMT
You can do this with data validation but there are limits as to how much
"protection" this will give you. You can try this out and see if it meets
your needs.

Create this defined name:

Goto Insert>Name>Define
Name: SH1C3
Refers to: =Sheet1!$C$3
OK

Select the range Sheet2 C3:C10
Goto Data>Validation
Alow: Custom
Formula: =SH1C3=""
Uncheck Ignore blank
OK

Users can not ENTER (type) data into Sheet2 C3:C10 unless Sheet1 C3 is
empty. They can, however, drag and drop, cut/paste, copy to or delete.

Biff

> Hello Excellers,
>
[quoted text clipped - 4 lines]
> Greetz,
> Reijer

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.