Microsoft Office Forums Query regarding MS Excel usage

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2019, 07:56 PM
Ashith Rai Ashith Rai is offline Query regarding MS Excel usage Windows 10 Query regarding MS Excel usage Office 2007
Novice
Query regarding MS Excel usage
 
Join Date: Apr 2019
Posts: 1
Ashith Rai is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Query.xlsx (10.6 KB, 1 views)
Reply With Quote
  #2  
Old 04-16-2019, 10:48 PM
ArviLaanemets ArviLaanemets is offline Query regarding MS Excel usage Windows 8 Query regarding MS Excel usage Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

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).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query regarding MS Excel usage 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
Query regarding MS Excel usage Copy resource usage to excel cossie2k Project 1 11-29-2015 10:05 AM
Query regarding MS Excel usage 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


All times are GMT -7. The time now is 05:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft