View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doc Doc is offline
external usenet poster
 
Posts: 4
Default Problem with Excel 2002

I created an Excel file with Excel 2000. The file
contains Textboxes and CommandButtons. The VB code
associated code with the controls ran fine.

I brought the file home to modify on a computer that is
running Excel 2002 and the following error arises.

It appears VB is not recognizing the Activate method for
the textboxes or commandbuttons. When it encounter the
code, ActiveSheet.TextBoxName.Activate or
ActiveSheet.CommandButtonName.Activate
I receive the error: Runtime error 1004
Activate method of OLEObject Class failed

Any suggestions?

Thanks.