Excel Template file and VBA code - Update final excel file

[kvalli]

Hello,

We have a set of Excel reports generated from the template file.

I want to hide a set of rows in the final report based on the cell value. So, will it suffice to create a public function using VBA code in template file? Do I need to put it in an event trigger?
Conceptually will this even work?

The final excel is generated every week based on the template and its contents overwritten.

Thanks,
V