One feature that the trust center offers is Trusted Locations - if you
identify a folder (or several folders) to be Trusted Locations, you should
not be prompted to enable macros within Excel files opened from those
locations. This works - I use it myself. Key point here is not to put an
Excel file into one of those locations until you DO trust it and know the
macros to be safe to use.

Office Button - Excel Options - Trust Center - [Trust Center Settings]
button - then Trusted locations in the list in the left hand panel.

"Ang" wrote:

I have a user on Excel 2007 working in spreadsheet with macros (simple sort
buttons), i have set the macros to be enabled in: MS Office Button/Excel
Options/Trust Centre/Trust Centre Settings/Macro Settings/Macro Security,
however, this is not staying. It is ok for the then and now, however user
closes and reopens the spreadsheet and the same happens, a message appears
asking to set the macros to enable and she has to do this each time. Please
can anyone tell me how to set this permanently and if there are low/med/high
settings in Office 2007 for macro security. Thanks.