I have written some code which opens another file which has macros and
extracts data. I don't need to run any macros in this other file. Is there
a way of turning off the button to run macros when the other file opens up?
Also I'm doing this in 2003 at the mo but is there any difference with 2007?

Many thanks

James