LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002/2003 problem Palpha32 Excel Discussion (Misc queries) 0 March 23rd 09 03:18 AM
Excel 2002 Installation Problem Philip Gabe Setting up and Configuration of Excel 2 December 1st 07 01:34 AM
excel 2002 formatting problem [email protected] Excel Discussion (Misc queries) 1 April 25th 07 03:26 AM
Iteration problem (Excel 2002) Stefan Kasserra Excel Worksheet Functions 1 July 17th 06 11:38 PM
problem in excel 2002 and windows xp aries58 Excel Programming 6 November 26th 03 04:43 AM


All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"