top of page

The first video of 2021 added to my YouTube Channel!

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:



 
 
 

2 Comments


Ricko
Dec 01, 2024

Hello, what did you use to record your videos from your Mac screen and webcam? I found an article on the Internet - https://www.movavi.com/support/how-to/mac/how-to-record-screen-with-audio-on-mac.html where they talk about several ways to record a Mac screen with a microphone, please tell me, is this suitable for beginners?

Like

Alan Jarvis
Alan Jarvis
May 06, 2024

Hi Ratale

I use Techsmith Camtasia :)

Thanks

Alan

Like

Purchase: Super Memory Essentials, Leadership and Management Essentials, and The Complete Excel Series (including Levels 1, 2 and 3) are available for purchase via the Udemy platform...just click " Buy Now..." or "Purchase Lifetime Access..."button and your special discount will be applied automatically. This option give you lifetime access, and is backed by the Udemy full 100% money back guarantee. So, if you're not entirely happy, you can get all of your money back, no questions asked.

All Courses are also available to UK students via https://www.reed.co.uk/courses/?keywords=alan%20jarvis

That sounds good, right? I thought so. So, choose your path to learning, and I'll see you in the course(s).

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon
  • YouTube

© 2023 by Personal Life Coach. Proudly created with Wix.com

bottom of page