On Jan 13, 10:33*am,
wrote:
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? *

Which button are you referring to? Is this a button that you have
placed in a sheet, or the menu item under Tools and it's counterpart
in the Toolbar. If it's the later, your best bet is to simply remove
the Macro Toolbar from the machines where this might be run.

Maury