macros in 2010

[daffy]

Hi All

I have updated to Excel 2010

What i am stuck on is:

Once i open a file and enable the macros, the next time i open the file the macros are automatically enabled.

Is there a way to be asked each time like in excel 2003 or a way to roll back so its like the first time the file is being opened in 2010

I am working on a project and at times want the macros to be disabled for the start of opening the file.

Is this simple but im missing something?

Cheers

Don

 

[Domenic]

Try...

File > Options > Trust Center > Trust Center Settings

...and change the settings as desired.

 

[daffy]

Thanks

Don