I have code that opens a Workbook.

When this code runs in Workbook_Open() it works fine. However when I
execute the same code in a normal Function call it doesn't work.

I have moved the code that does the actual opening of the workbook to a
different subroutine "Test_Call". When I call it from Workbook_Open, it
works. When I call it from a Function Call, it doesn't work. When I put
the call to "Test_Call" into a Macro, it works.

Do you have any idea what's going on?

Mac Lingo

If you're calling the function via a worksheet formula it will not work.
Formulas only return a value to the cell they are in. They cannot affect
other cells or perform any actions.

--
Jim
"Mac Lingo" wrote in message
link.net...
I have code that opens a Workbook.

When this code runs in Workbook_Open() it works fine. However when I
execute the same code in a normal Function call it doesn't work.

I have moved the code that does the actual opening of the workbook to a
different subroutine "Test_Call". When I call it from Workbook_Open, it
works. When I call it from a Function Call, it doesn't work. When I put
the call to "Test_Call" into a Macro, it works.

Do you have any idea what's going on?

Mac Lingo

If you are calling form a VBA function, either

a) precede the call by thisworkbook, e.g. thisworkbook.workbook_open
b) move the code to a procedure in a normal code module and call that (from
the Workbook_Open as well)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim Rech" wrote in message
...
If you're calling the function via a worksheet formula it will not work.
Formulas only return a value to the cell they are in. They cannot affect
other cells or perform any actions.

--
Jim
"Mac Lingo" wrote in message
link.net...
I have code that opens a Workbook.

When this code runs in Workbook_Open() it works fine. However when I
execute the same code in a normal Function call it doesn't work.

I have moved the code that does the actual opening of the workbook to a
different subroutine "Test_Call". When I call it from Workbook_Open, it
works. When I call it from a Function Call, it doesn't work. When I
put
the call to "Test_Call" into a Macro, it works.

Do you have any idea what's going on?

Mac Lingo