Hide non continuous rows using a macro

Hi,

I have recorded a macro but because my rows are not continuous it is rather jumpy when running. Is there any way to stop this? perhaps selecting all rows and hiding at the one time?

Please Login or Register  to view this content.

thank you!

JosephP,

Looking for your help on something similar please. I am looking to hide multiple rows and columns on different sheets. The code below works but again because I'm selecting the different sheets its jumping. Do you have a solution to this?
Thanks,

Nicola

Please Login or Register  to view this content.

thanks again for the help and quick response!

For some reason I'm now getting a 'run-time error '1004' Unable to set the Hidden property of the Range class' and the following line is highlighted? Do you know why this could be?

Please Login or Register  to view this content.

Just realised it's when I have my vba project password protected. Is there anyway to fix this? I do not want others to view my code.

Nicola

Could this be why - I am using the code below to hide the cost prices then protect the workbook. When I run the lockandsave macro without running the hidecostprices it works fine and vice versa?

Please Login or Register  to view this content.

If I run the 'hidecostprices' macro before running the 'ProtectAll' macro should this not work? I thought running this at the beginning would run this first. Sorry I'm just getting started.

Got it! In my first code I was hiding the cost prices then protecting. In my second code I was trying to unhide the cost prices before unprotecting. Thanks for the help again!