It's been a while, but I'm back, and I have just added another great new video to my YouTube channel!
If you like this video, please hit the subscribe button!
This is a lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming), which will teach you everything you will ever need to know about coding in VBA.
All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.
A great question from a Level 3 student, Anat.
This lecture is about how to protect specific cells (lock them) so users can only access the cells you want them to have access to. Ideal if you have a list of some kind, where you only want the user to be able to add new entries, but not change any of the existing data.
What we do on a WorkbookOpen event, is lock everything except the first blank row, and also lock any cells in that row where we have formulas (so users can't break them!).
Next, we will add some automatic data validation. This will ensure that your users only input the kind of data that is expected in each column...so a date cell can only hold a date, for example. If it turns out that the user has entered something incorrect, the validation routine will colour any errors in in red, so they are obvious to the user and they can correct them.
Nice and simple, and very useful!
Enjoy!
Be sure to check out the other videos on the channel...there are quite a few!
Videos in the Level 1 series:
Videos in the Level 2 series:
Videos in the Level 3 series: