Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter information in one and lock the other, OR vise versa
Hello,
I am an intermediate user of excel, however my knowledge of VBA is a little rusty. I am currently stumped on this problem for a worksheet I working on: Worksheet is "RateSheet" and already unlocks and locks certain ranges on worksheet.change event Range "A" is D12:D1000 Range "B" is E12:E1000 Validation for both ranges is positive currency values I want to compare a cell from A to the corresponding cell in B and allow information to only be entered in one OR the other cell. Therefore if the user enters a number in A, the user will not be able to enter any values in B, and ultimately B will be greyed out as well. The same goes for B, a value entered will have the same lockout results in A. If A had information and B was locked out, deleting or clearing A would unlock B. Hope this makes sense... I've searched but have not found exactly what I am looking for... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell After Enter Command | Excel Discussion (Misc queries) | |||
Outlook Calendar Reminders link with Excel, vise versa | Excel Discussion (Misc queries) | |||
Lock information | Setting up and Configuration of Excel | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
Change rows to columns and vise versa | New Users to Excel |