It wasn't meant to be picky, sorry it seemed that way! ;180310 Wrote:
A bit picky but I like where you're coming from :-)

"Simon Lloyd" wrote:


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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Accessing an Excel file which has macros - The
Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=49795)




--
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