Excel 2007 : Macro Code Stopped Working

**stevo_300** · 04-06-2010, 06:26 AM

Hi,

Im currently trying to develop some code that upon populating a cell the colour of it will automatically change (excluding column "A" and rows 1 and 2)

However during my testing it seems that the code no longer even tries to run?

Im guessing there is a setting somewhere that has been accidentally changed? Please could someone direct me too this?

Thanks

Steve

**sweep** · 04-06-2010, 06:42 AM

Hi,

Have you got macros enabled?

Could you post your code?

**stevo_300** · 04-06-2010, 06:46 AM

Hi, my code so far is:

Please Login or Register  to view this content.

I will just check whether they are switched on

**sweep** · 04-06-2010, 07:44 AM

you may want to edit your posts with code tags, as per the forum rules while you're checking.

**stevo_300** · 04-06-2010, 07:47 AM

Ok, the code seems to run once after re-opening the file but then thats it, does anyone possibly have any ideas?

The code now is:

Please Login or Register  to view this content.

**stevo_300** · 04-06-2010, 07:57 AM

Hi Sweep,

Ive found my most recent problem (The EnableEvents switch was buried in an if statement and as such not being recognised

Thanks for your time