error excel if embedded in word documents

[Guest]

I have a file excel with some code VBA to manage some population. It works
right stand-alone, but if I embed the excel file in a word documents it goes
in error (error that stop excel itself). Because the code is fired by a
combobox change, if I write a random cell for example before fire the code
the error doesn't appear, but if the first action on the file is changing the
combobox I get the error (seems that need somthing like a "set context").
I use office 2000 pro. Thanks in advance for your help.

 

[Guest]

The workaround used for the moment is to valorize the "linkedCell" attribute
of the combobox choosing a cell behind the combo itself and reference this
cell in the code when i need the combobox value ... I don't know why but in
this seems all ok.
Bye.

 

[Tom Ogilvy]

In the click event you also might try

application.Activecell.Activate
as the first line.