Excel system for checking Lottery numbers

Some years ago I sought the assistance of the Help Room to obtain a system for setting up a grid with National Lottery numbers and being able to quickly check the numbers which came up at each Draw..
A contributor supplied me with such a system and this has worked well - until last weekend when none of the numbers I entered were recorded on the grid. A friend runs a back up grid and he sent me a copy, but that didn't work either!
Usually I am given a warning about the Macro I need to use in order to open the grid, but this does not now appear. I confess to having very little knowledge of Macros, but wonder if it is a case of re-installing them, but do not know how to do this!!
My System is Windows XP and I use Microsoft Excel 2007 for operating the grid.
I run two Syndicates - one with 70 lines and the other with 60.
Any help will be appreciated, as it is a lengthy business, crossing off lots of numbers after each draw!!!

  VoG II 16:18 20 Mar 2011

Click the Office button (top left), click Excel Options, tick Show Developer tab in the Ribbon, then click OK.

On the Developer tab click Macro Security then tick Enable all Macros... then click OK.

This is perfectly safe provided that you have an anti-virus program.

Many thanks for your assistance with this. Just run tests on both grids and all working well!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?