You could use this line of code but you need to be more specific on what
button where.

Code:
--------------------
Application.EnableEvents = False
--------------------
you would have to tie it in with an IF statement so it will only be used
on a certain sheet or workbook!, don't forget to turn it back on
;180058 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?
Also I'm doing this in 2003 at the mo but is there any difference with
2007?

Many thanks

James


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49795