Fillable Bullets Form For Free

welcome to the final tutorial for bulletproofing forms and excel here I finally get to show you how to actually bulletproof the form so that people can't click these outside cells or delete any of this data that can only input data where they are supposed to be able to do that and we're also going to have to update our macro to work with this and we're gonna hide all the extra data we made in the last tutorial so this tutorial is gonna round everything up if you haven't seen the previous tutorials I highly recommend that you go ahead and watch those because I'm going to assume that you are up to date with all that before we start check the video description and click the link to teach Excel so you can download the files for the tutorial and follow along and make sure to subscribe and accept notifications so you can see all the new tutorials so this is where we left off we have our validation and our formatting our error count and our show error and our macro everything is working as of the last tutorial but let's get rid of all this data now it looks ugly it's annoying and the user can accidentally delete it and break everything so what we want to do it's actually pretty simple you go to the review tab and click protect sheet do that by default both of these options will be selected hit OK once you do that you're not going to be able to delete or augment any of the data by default in fact by default you won't even be able to do anything with these so this is the feature we're going to use and now let's adjust it to make it work exactly how we need it to work so the first thing that we want to do is we want to make sure that all of these cells here are editable but the others are not so what we can do is click the cells hit ctrl select each one it's going to make this go faster then right click go to format cells go to the protection tab and uncheck locked so by default all of the cells in the workbook in the worksheet are locked and that means when we click protect sheet up here they're gonna be locked you're not gonna be able to do anything with it unchecking this for specific cells says hey keep these open let the user do stuff with them so uncheck locked hit okay now if we go back to protect sheet hit OK you'll notice it here I hit the Delete key or anything still an error but over here I can type in stuff I can add values but I try to add a value down here error but still I don't want the user to be able to select all these things down here not very user-friendly let's unprotect the sheet again hit protect now look to this little window the first thing here is select locked cells the other one is select unlocked cells by default these are the only two options that are going to be selected you've got many other options you can check out but what we want to do is to uncheck select locked cells hit OK and now we can't even click over here we can see the data but we can't click there we can only click here and our unlock cells or use the arrow...