How to call on worksheet.change event in a macro?

Hi,

In school, I have a worksheet that enables me to choose a student. Below is listed every possible Subject. It uses index/match lookups to find data relevant to that student. I am using code attached to the sheet (View Code) to hide rows with no data. This is made as a Worksheet.Change Event so whenever I select a different student it automatically refreshes to display only those rows applicable to the student. All of this works fine.

I now want to create a macro that will print the sheet for all of the students, one-by-one. The process of changing the student selection one-by-one is fine, within a For ... Next loop. However, I cannot get it to run the worksheet code to refresh the rows displayed, before printing the sheet. So the data is updating from one student to the next, but the display of the appropriate rows is not.

So, any ideas what instruction I need to put in the macro to make the worksheet.change happen?

Many thanks...

I guess your 2nd macro is changing a value which should fire the change event? As Rory inferred, your Application.EnableEvents should be set to True at the end of your change events code. It should also handle errors so that it is set back to True.

It is hard to help without seeing code or an example workbook.

You could set a Modular Sub to take input parameter as the Target range. Then your other macro could just Call it like your change event macro would. Obviously, you would have to call it with the Target range directly. e.g.

Please Login or Register  to view this content.