Query regarding MS Excel usage

A1S2H3I4T5H

Starting to get Involved
#1
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.
 

Attachments

Elsmar Forum Sponsor
N

ncwalker

#2
First, there's no drop downs in it that I can see.
Second, it is possible to change protection based on user input via VBA programming. But you'd be better off on an Excel forum than this forum.
 
Thread starter Similar threads Forum Replies Date
S Query regarding completion of MedWatch 3500 Form Other US Medical Device Regulations 3
G Query on the pharmaceutical excipients registration in Korea Various Other Specifications, Standards, and related Requirements 1
V FDA 510K - Pre Submission Query US Food and Drug Administration (FDA) 6
A Sterile Packaging Quick Query EU Medical Device Regulations 5
Proud Liberal Power Query to combine multiple tables of unequal number of columns Statistical Analysis Tools, Techniques and SPC 1
V Query on Rubber products (EPDM, Silicone, BR, NBR, Neoprene, TPE) Manufacturing and Related Processes 5
V Query on Poly Carbonate (PC) - Durability of the Product Manufacturing and Related Processes 24
V Query on PA66+GF15% - Color variation (Natural to Yellowish) problem Manufacturing and Related Processes 20
P Internal Audit Matrix Process Query ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 38
M Technical Query (TQ) Nonconformance and Corrective Action 1
D minitab macro to pull access query with parameters Using Minitab Software 1
R Medical Device and Accessory Establishment Registration and Listing Query Other US Medical Device Regulations 7
B Query on Medical Device Electronics RoHS Certificate Statement RoHS, REACH, ELV, IMDS and Restricted Substances 3
A 7.5.1.3: Verification of job setup query, sample WI required. IATF 16949 - Automotive Quality Systems Standard 5
A Query about ISO 9001 Certification Documentation for a Service company ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
N Controlling Records query that may cause some serious trouble for me ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
V Query on TS 16949:2009 Certification for a Tool and Die Sales & Service office IATF 16949 - Automotive Quality Systems Standard 3
C Creating a Multiple Table SQL (Structured Query Language) Query in Minitab Using Minitab Software 10
G Query on Capability of Stdev Specifications Capability, Accuracy and Stability - Processes, Machines, etc. 9
N Must Templates be controlled? Controlled Document Query ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
N Controlled Documents Distribution Query - Home Care Company ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
R Query on Concentricity Inspection Manufacturing and Related Processes 11
Q OEM (Original Equipment Manufacturer) PPAP Applicability Query IATF 16949 - Automotive Quality Systems Standard 4
J Reduction of Pull Off Test Inspection Frequency - Capability Query Quality Tools, Improvement and Analysis 1
P Query about TS 16949 and a Multi-Disciplinary Approach IATF 16949 - Automotive Quality Systems Standard 3
A Query on Certification Man Days for ISO 9001:2008 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
T Titles for Quality Functions - Very small business quality department query ISO 13485:2016 - Medical Device Quality Management Systems 17
F Good Documentation Practices Training Materials Query Training - Internal, External, Online and Distance Learning 6
J Help with Microsoft Access ODBC Database Query Criteria Misc. Quality Assurance and Business Systems Related Topics 35
S Identification and Traceablity - Audit Query - AS9100 REV B - Clause 7.5.3 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
S TS16949 Query on Subscribing and Non-Subscribing Customer IATF 16949 - Automotive Quality Systems Standard 2
J Need Some Access Query Help - Error message saying "Numeric field overflow" Quality Assurance and Compliance Software Tools and Solutions 2
D 7.4 Purchasing - Query on Indirect Material Qualification ISO 13485:2016 - Medical Device Quality Management Systems 0
J Question, query, poser, MMMMMMM QS-9000 - American Automotive Manufacturers Standard 6
D What are the rules regarding coverage in internal audits? IATF 16949 - Automotive Quality Systems Standard 0
D What are the IATF rules regarding doing internal audits remotely? IATF 16949 - Automotive Quality Systems Standard 2
A Question regarding new VDA_AIAG fmea approach for process FMEA FMEA and Control Plans 0
H Regarding Double Insulation & Caution Symbol on Product according to IEC 61010-1 CE Marking (Conformité Européene) / CB Scheme 6
H Regarding UL Certification CE Marking (Conformité Européene) / CB Scheme 6
J Question regarding classification of custom made device EU Medical Device Regulations 5
O Regarding design and development requirements for a medical device EU Medical Device Regulations 6
H Regarding EAC-MED mark Other Medical Device Regulations World-Wide 0
I Request for information regarding remote medical monitoring software (its technical documentation and the IUD system) IEC 62304 - Medical Device Software Life Cycle Processes 2
S Question regarding AQL - ISO 3951 Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
H Regarding compliance according WEEE Directive CE Marking (Conformité Européene) / CB Scheme 6
H Regarding Recycling symbol (The Mobius Loop) applicable for the given materials REACH and RoHS Conversations 4
H Regarding Usability Engineering File according to IEC 62366-1 CE Marking (Conformité Européene) / CB Scheme 2
H Regarding external surface temperature limit requirement for lab incubators. CE Marking (Conformité Européene) / CB Scheme 2
H Regarding the validity of EMC & Safety test reports without NABL & ILAC-MRA mark. CE Marking (Conformité Européene) / CB Scheme 2
H Regarding EMC & Safety retesting requirements of the product CE Marking (Conformité Européene) / CB Scheme 2

Similar threads

Top Bottom