How are you invoking that macro that opens that other workbook?

If you're using a shortcut key and that shortcut key includes the Shift key,
then drop the shift from the shortcut key combination.

Holding the shift down when opening a workbook tells excel not to run the
auto_open/workbook_open code. It can also confuse excel enough so that it stops
when you think it shouldn't.

br_turnbull wrote:

I have a macro that opens another workbook and adds data to it, before
the data is added a macro in the destination workbook needs to be run
so that columns, etc can be added for a new month.

I renamed the macro (destination workbook) Auto_Open and tried calling
it in the source macro by

Workbooks.Open (filePath)
Workbooks(fileName).Activate

ActiveWorkbook.RunAutoMacros Which:=xlAutoOpen

but it never actually runs the macro in the destination workbook called
Auto_Open, an ideas?

Thanks in advance.

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