Hey guys welcome back. So in this video we're going to discuss the workbook sheet deactivate event. So the workbook sheet, the Activate event triggers whatever code you put in it whenever you deactivate any worksheet on your workbook, and also it has a parameter is called sh and this parameters type is a worksheet object. And it basically refers to the worksheet that you have just deactivated. So you could have a message box for example, here you have D activated, and then a space and then we're going to concatenate the on sh dot name. So now if I deactivate the sheets on sheet two, if I activate ci 28, for example is going to say you have D activated sheet two.

So the SH dot name refers to the name of the sheet that's just been deactivated. You could also maybe put an if statement to make it Run only for a certain sheet. So you could say if sh dot name is equal to sheet two, then and then we're going to have an end If so, if the name of the sheet is equal to sheet two, and that means the name of the sheet that has been deactivated because as he refers to the sheet that's just been deactivated. So the name of the sheet that's just been deactivated is T two, then you would run the message box. Okay, and make sure to write the name of the sheet with the same upper and lowercase letters. Because if you write the S at the beginning, for example, here of shih tzu as a small letter, and here it's a capital letter, it will not work.

So I'm going to go to sheet two from sheet 28 and you will see here that this code will not run because the name of the deactivated sheet is not sheet two, okay. But now because she is the one that is active and if I deactivated the code is going to run because I put a condition that you would own Run, or the message box, I mean, would only run if the name of the deactivated sheet is sheet two. So you could do that. Although actually, you could just go ahead and write this code in sheet two in the sheet two events module here have the select the worksheet here and select deactivate. And this way, you can write whatever code you want to write in the worksheet, deactivate event for that specific sheet. But you know, it's another way to do it and maybe you don't know the name of the sheet.

So maybe you have several sheets cold they have a having a certain prefix on them. So maybe sales, one, maybe or and then there is sales to for example, very sales to for example, and sales three. Okay. And you want the code only to run if the name of the sheet has the word sales in it, so we can do that, actually. So this can be done by by doing what is called the wild card match. Okay, so this is something actually new that we're going to learn.

So you could write if sh dot name like, and then you would open double quotes. And then you would put an asterisk and put the name of the sheet that it would be like so it's sales, for example. And this means that the name is going to contain sales in it, and we're going to put an asterisk asterisk as well and then close the double quotes, then maybe message box you have deactivated a sales sheet and actually, when you do a wildcard match, this is just the beginning. means that the name, the word sales could have something before it. And this one means that the word sales could have something after it. But usually if I'm searching for a certain word, put, put it as if it would have something before or something after you go more specific and I'd only one of those two asterisks if you want.

So let's try that. Now if I deactivate any other sheets, or if I select sheet one, for example, actually, I've just activated the a sales sheet which was sales, three, or sales two, I don't remember but anyways, one sales sheet has been deactivated and this is why the message box has been triggered. Okay. And now if I deactivate this sheet one that does not contain the word sales in it, nothing will happen. Okay, but if I go to any other sales sheet and I deactivated And then go to maybe sheet two here. So from sales one to sheet two, the code has been triggered.

So this will work with any sheet that has the word sales in it, for example. Okay, so this code is going to work for any sheet that has the word sales in it. I don't typically use this event a lot, but if there's something that this event would prove useful for you to use it in, please let me know. I would be really interested to know it. Okay, so that's it, guys for the workbook sheet D activate event. Thank you very much for watching this video, and I'll see you on the next one.