Ive got an excel spreadsheet which has been developed in excell 2003 and has
macros and vba running in the background to populate a pivot table. One of my
associates is trying to open it in excel 2007 where it wont run the macros
unless macro security is totally turned off.

In 2003 there was an enable/disable macro warning but i cant seem to bring
up that kinda switch in this. Ive gone through trusted security settings and
tried to manipulate it from there but what i want is for the user to be able
to click on yes or no as in 2003.

what workaround is possible for this?

With thanks,

Amit