Okay guys, so now we're going to have an exercise for the for each loop. So we're going to write a macro using a for each loop to hide all the sheets in this workbook, except for the sheet that is called exercise. So we're going to hide all the sheets in this workbook here called for each loop except for the sheet that is called exercise. And as a hint, you will actually need to use a property for sheets that is called the dot visible property. So if you set the dot visible property to be equal to false, then the sheet is going to be hidden. You can also set it to excel sheets hidden and if you set the property equals to true, then the sheet is not hidden, it's going to be visible and you can also set it to excel sheet visible.

And I've included here the link for the dot visible property for its page on MSDN. So please have a look at it. Read about this property. I need you to get used to reading about properties and methods that you don't know about on MSDN. You know, this is part of learning actually on the course that you can get information yourself. Okay?

So you need to get used to going to MSDN and reading about methods and properties that you don't know about. Okay, this is part of the learning process. I have included the answer for this exercise here on this module called exercise answer. So please attempt the exercise and if you get stuck, have a look at the answer, but please try to solve the exercise and if you have any questions, please leave them in the q&a section. Thank you very much for watching this video and I'll see you on the next one.