Hiding multiple rows

So I have several sheets that hide and unhide rows based on the word "unhide" in a cell.

The code I use is below, it seams to run very very slowly, is there a faster alternative to this?

Basically it takes a sheet, looks at each cell from 5 to 32 and hides or unhides based on the word "unhide" then it goes to the next sheet. Just takes forever.

Please Login or Register  to view this content.

Try setting calculation to manual at the top of your code, and then reset it to automatic at the end.