Speed up the macro coding 150 sheets

Hello All,

I have report contains more than 150 sheets, so based on the “H” column It will visible also every sheet “F1” cell needs to update the “True” if the sheets were visible then. So here the problem is it will take too much time to visible the sheets and update the “F1” cell value.

Can you suggest me how to speedy the below said macro?.

Please Login or Register  to view this content.

Thanks/Raju

i forget to update these lines also in that coding.

Please Login or Register  to view this content.