On Jun 29, 8:20*pm, Dave Peterson wrote:
First, I would use the worksheet event, not the workbook event.

I'd move the code from behind the ThisWorkbook module to the worksheet module
for BOM.

Second, I'm betting that you upgraded from xl2002 (or earlier) to xl2007. *In
xl2002 (and below), hiding a row didn't cause a recalculation.

But xl2003 added some new arguments to the =subtotal() function. *That now can
ignore rows hidden manually -- not just hidden by an autofilter.

dont tell me that.... I asume/hope that by default it reads them all,
otherwise I just got more work :(


So I'm guessing that each time your code hides a row, excel says: *Time to recalc!

actually, it runs all the time - there is no clear reason for it to do
so.... it just stands there, runs, waits a second and then again...


And off it goes again running your event code.

I'd try this (in that BOM worksheet module!):

thx
will try