Help needed to make 2013 VBA code work on 2007

[craigten]

Hello all, I have been using this code to create pop ups when certain conditions are met when I scroll through tabs, it works well on 2013, but as I expected it doenst work on 2007, Can anyone help me make it work on the older version 2007.

Please Login or Register  to view this content.

Thanks

Craig

[xlstime]

Hi Craig,

its working fine...and as per my knowledge still not major change found in vba's

Enjoy..
Team XLS

[craigten]

Hi xlstime

Thanks for the quick response, ill check again and let you know. (maybe a setting ive changed without knowing)

Thanks you

[craigten]

No, still not working...I transferred the file with the code in it to a machine with excel 2007 (for warning pop ups), the code doesnt have any effect on the file when i use it in 2007,

Any ideas

Thanks

[craigten]

I have the feeling it could be do with saving the file as 97-2003 workbook as there isnt a 2007 option, ill try saving it as macro-enabled workbook see if it does the trick. If anyone can suggest anything would be much appreciated.

thanks

Craig

[craigten]

It worked... now working on 2007,

Thanks

Craig