Hello
Can someone help me in merging the below two VBA codes to into one VBA code.
Please Login or Register to view this content.
Please Login or Register to view this content.
Hello
Can someone help me in merging the below two VBA codes to into one VBA code.
Please Login or Register to view this content.
Please Login or Register to view this content.
Untested, see if it works for you
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Try calling the 2 subs and keeping Worksheet_Change clear of clutter
- makes it easier to add other things later if necessary
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hello
Above code is working but Not all the cells are getting locked.
Hello
Above code is working but Not all the cells are getting locked.
Which code are you referring to?
The target cell has to be in column 2 for the locking part of the code to execute. Otherwise only the second part of the code will execute. Same thing with kev- 's version, it only calls the locking macro if target is in column 2.
Above code is working but Not all the cells are getting lockedPlease Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks