+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : xl2007 file saved with xl2003: activecontrols disappear

  1. #1
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    xl2007 file saved with xl2003: activecontrols disappear

    There is a file working OK in xl2007 (Home and Student) that has some ActiveControls on it: CommandButtons, spin buttons and a label on a worksheet.
    The file is supposed to be sent to recipients who have xl2003 and they save it as an Excel workbook.
    Opening the file surprise hits: all the active controls are transferred to picture images....
    e.g.: CommandButton1 was an ActiveX button, no it becomes a picture image that is called as 'CommandButton1'.

    On opening the file I get an error message that I have attached, informing that:
    'Uninitialized ActiveX controls will not be opened with this version of Excel.'

    Any chance I can initialize the ActiveX controls by VBA on the event the file is opened in xl2003 ?

    Thanks...
    Attached Images Attached Images
    Last edited by Gabor; 06-28-2009 at 07:33 AM. Reason: adding information
    Regards,

    Gabor

    Protect trees.. maybe one day we need to climb back....

  2. #2
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    Re: xl2007 file saved with xl2003: activecontrols disappear

    Need advice what would be the best forum to post this.
    Thx

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: xl2007 file saved with xl2003: activecontrols disappear

    Save the file, from xl2007, as an 97-03 compatible file.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    Re: xl2007 file saved with xl2003: activecontrols disappear

    Thanks. Works OK.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1