Hello friends,
I'm stuck. Kindly assist. Excel sheet attached
I will like help with a VBA codes or script such that when Cell "C19" returns 'FAIL', cells C21 to 26, C29 to C36, C39 to C58 will be locked from further editing else if it returns 'PASS' then the cells can be further editable
I would also like to have a POP UP message prompt like 'You may not proceed' when "C19" shows fail
Thank you
Best Regards,
Oloyejawnson
Swift assistance would be highly appreciated..
I am away from my PC so cannot download your file, but this is one way to do what you want.
Use a change event macro in the sheet module - this one
The UNION function allows you to join your various ranges into one range, use commas to separate your ranges.
Please Login or Register to view this content.
This would remove any edit from a "locked" cellPlease Login or Register to view this content.
Click on this solved thread where the OP wanted something similarPlease Login or Register to view this content.
Last edited by kev_; 02-20-2018 at 05:37 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hello Kev,
Thank you so much. Appreciate
However, I'm unable to run or apply the codes as the macro is not showing on the Macro list when I try to run the script. Am I missing something?
Please what can I do?
See screenshot below.. thanx!
Change Macro.PNG
Macro.PNG
Here is a complete macro for you
Test in attached workbook
I have included dropdown in C19 with "Pass" and "Fail" as possible values
Macro is in the sheet module (right click on sheet tab \ View Code to see it)
It is an event macro
You do not run it - it is triggerred automatically
It does not appear in the list of macros ("Private" prevents it being visible)
EnableEvents=False prevents the macro cell edits triggering the macro again
Please Login or Register to view this content.
Last edited by kev_; 02-21-2018 at 03:33 AM.
Thanks a bunch Kev.. it works fine now!
Cheers bro!
Good
Please mark thread SOLVED (click ThreadTools at Top of Thread)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks