+ Reply to Thread
Results 1 to 4 of 4

Command Button changes now cause Run Time Error 438

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    NC
    MS-Off Ver
    Office 365
    Posts
    11

    Command Button changes now cause Run Time Error 438

    I have the following code in a separate module that is called from code in a Workbook_Open() routine in ThisWorkbook object.

    I get a Runtime error 438 Object doesn't support this property or method at the line .cmdMaterialCtrl.Caption = "+". I get the same error at other places in the project where any thing happens to command buttons programmatically. The same error happens on all computers I use to run the code.

    It was running without issue until recently. I have backups of this file going back several years and I even get this error when I open those old files as well.

    Please Login or Register  to view this content.
    What could have changed to cause this error to start happening on code that ran successfully in the past?

  2. #2
    Registered User
    Join Date
    06-17-2009
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    84

    Re: Command Button changes now cause Run Time Error 438

    May be related to Microsoft update yesterday. It hit us all hard yesterday. Several posts regarding buttons and commands not working
    http://answers.microsoft.com/en-us/o...c-74a9abdc9493

  3. #3
    Registered User
    Join Date
    10-14-2009
    Location
    NC
    MS-Off Ver
    Office 365
    Posts
    11

    Re: Command Button changes now cause Run Time Error 438

    Will you please repost the link. That one appears to be dead.

    Thanks,


    Quote Originally Posted by Epscan View Post
    May be related to Microsoft update yesterday. It hit us all hard yesterday. Several posts regarding buttons and commands not working
    http://answers.microsoft.com/en-us/o...c-74a9abdc9493

  4. #4
    Registered User
    Join Date
    10-14-2009
    Location
    NC
    MS-Off Ver
    Office 365
    Posts
    11

    Re: Command Button changes now cause Run Time Error 438

    This post solved my issue.

    Thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-07-2014, 07:05 AM
  2. Run Time Error 1004 when selecting range on another sheet using a command button
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 07:43 AM
  3. [SOLVED] Command Button to Call User Form - Run Time Error 1004
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2013, 11:27 AM
  4. Command Button Error
    By mgalterio in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-30-2012, 03:27 PM
  5. Command Button to reset PivotTable Fields to "Show All" - Run Time Error 1004
    By JenThurow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2012, 01:33 PM

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