Macro Auto run

Hi Guys,

New to Macros and VBA but ...

I have a simple Macro to hide rows if a cell value is NO called "Sheet1.ZeroTest"

this works but i have to run macro manually each time

So i have looked around and see i need a Worksheet change function to call this automatically if the cell contents change to 'YES'

I have something like this

Please Login or Register  to view this content.

But my problem is i dont know where to put this in order for it to work...

I have the Macro in Sheet1, how do i add the auto run to sheet1 too

thanks
Saz

You place this code in the sheet1 code module.

When in excel right click on sheet1 and in the menu press "View code", here you insert the code

Steffen Thomsen

Thanks ...

So something like this :

Please Login or Register  to view this content.

Then please mark your thread as solved according to the forum rules, and remember to put code tags around your code.