#1
|
|||
|
|||
Query regarding MS Excel usage
Hi,
I had a requirement from MS Excel. Pls go through the Attachment When I select "Turning" through Drop Down, F5 must become uneditable When I select "Milling", D6, E6 & I6 must become uneditable This helps me make requirements to the user more specific. Pls check & let me know if this is feasible Thanks. |
#2
|
|||
|
|||
In case every field in columns OD:Speed can have only a certain set of values determined by description, it is possible using data validation lists in all fields, and making those lists depending on selection in column Description. It doesn't ecxactly restrict the entry, but for columns you want to restrict entry there will be nothing allowed to enter (the data validation list will be empty).
Otherwise I don't see a way for this. VBA doesn't help, as there is no event fired on activating another cell (as much as I know). |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export Resource Usage sheet into excel | Jshields2009 | Project | 4 | 03-09-2017 09:47 AM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
Copy resource usage to excel | cossie2k | Project | 1 | 11-29-2015 10:05 AM |
Exporting Resource Usage data to Excel | samg54 | Project | 1 | 08-02-2013 05:28 AM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |