Does Workbook.Open ever run from a Function Call?

  • Thread starter Thread starter Mac Lingo
  • Start date Start date
M

Mac Lingo

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.
 
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)
 
Back
Top