RunAutoMacros won't run unless you tell it to run.
Workbook_open will run unless you tell it not to:
application.enableevents = false
'open your workbook
application.enableevents = true
with .enableevents = false, then the workbook_open event won't fire.
br_turnbull wrote:
yes filename is a subset of filepath i.e.
filepath = C:\File\workbook.xls
filename = workbook.xls
But i have found a workaround using ThisWorkbook.Workbook_Open() runs
the macro when the workbook isn't opened manually. Any ideas how i
could mke this conditional, i.e. somehow i could pass it a value and
depending on the value wether it would run or not? the value would have
to be passed from the source macro.
--
br_turnbull
------------------------------------------------------------------------
br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479
View this thread: http://www.excelforum.com/showthread...hreadid=478739
--
Dave Peterson