Hi All
I need help with code to lock cell in the same row with "Environmental" or "Safety " value.
Column H Contains either Environmental" or "Safety
If Safety is selected I need the cell on the same row in column J to lock preventing someone from entering data
If Environmental is selected I need the cell on the same row in column I to Lock
I have written some code but it doesn't work it.
Hoping someone can help and show me where I went wrong
Please Login or Register to view this content.
this macro has to be at the sheet level not in a module.
here is a macro that might help you. When you use the Worksheet.Change event, Target should be a single cell. If it is not, then you should exit the Sub.
I programmed the unprotection of one column while protecting the other one. If you don't want this you may change the macro.
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Hi p24leclerc
Thank you very much for your help
It worked a treat
One last question I am trying to get the code to do 3 different things and I am getting the error Compile error no next without for,
I have looked and cannot find where I have gone wrong
See code
Your help is much appreciatedPlease Login or Register to view this content.
See the modified macro and the comments below:
Please Login or Register to view this content.
Sorry to be a pain
I have changed the Code as you have advised.
But it now does not seem to be working correctly
It does not protect the column required and causes all macros on sheet to stop running (without error)
I have attached the Worksheet and I am hoping you can have a quick look to see why it is not working
Reports.xlsm
None of the Worksheet_Change(ByVal Target As Range) actions are preformed
Letter does not become capital on K column
Time stamp does not appear when "Completed"
Collumns stop hiding when target is selected
Last edited by bouncingbudha; 04-07-2015 at 08:58 PM.
Attached workbook should now work.
The issue came from the fact that the EnableEvents=True was being bypassed by an IF statement in your code.
I don't understand all you want to do with this file but there are lots of macros
that are doing the same things.
As long as it works for you.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks