Enable Macros - How ?

Excel student and home edition

[Essex_boy]

Any one ?

Cant do this on a vista machine for 2007 Home and Student version of Excel, very odd so please give me instructions in detail ! Thanks

[PCInk]

All you have to do is (I have 2010 version but prob same in 2007):

Go to File, Options.
Then Trust Center, Trust Center Settings. Then, Trusted Locations and add a new location (where your Excel sheet is stored), remembering to click sub-folders (if needed).

Then in the Trust Center dialogue box again, go to Macro Settings (instead of Trusted Locations) and change the Macro Setting in there to Enable All Macros.

It's good to see Microsoft making their products so easy to use.

[Essex_boy]

NO such thing as 'Trust center' as far as I can see

[Essex_boy]

HA HA found it total accident !

[jecasc]

Great to see you are back already, Essex_boy. Hope you are better.

[LifeinAsia]

Hope you are better

Playing with macros in Excel is better?! :)

But ditto the sentiment!