RunAutoMacros won't run unless you tell it to run.
should have been stated as:
Auto_open won't run unless you tell it to run using RunAutoMacros.

Dave Peterson wrote:

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

--

Dave Peterson