Run-time error '438' -- Object doesn't support this property or method

.
HELP - PLEASE HELP!!!


I started to receive a Run-time error- '438' -- Object doesn't support this property or method.

This worked perfectly last night. However, when I tried to open the file(s) today I received the error. There are numerous backups of this file at different stages in its development all producing the same error. I tried opening the file on three other machines all worked perfectly. So apparently something changed on my machine, not the worksheet. All machines are running Office2007 on Windows 10

I did a few things to see if I could repair it.

1. Thinking maybe Microsoft may have done an update overnight, I did a "system restore" - but no help
2. I uninstalled/reinstalled MS Office twice - still no help.
3. I looked online for suggestions. I only found solutions addressing the Excel file, not a system problem. I do not believe this is a file problem, maybe an application issue although I did a reinstall.

Any suggestions would be GREATLY appreciated.
Thanks for viewing.

- - - - - - - - - - - - - - - - - - - - - - - - - -

UPDATE -

I did a reinstall of Windows 10 yesterday. After much hassle as expected, I did get it to work. However, when I opened the Excel file this morning the exact same error appeared. Again, I assume Microsoft did an update as I did nothing during the night. I really can't keep reinstalling Windows.

I posted this on MrExcel. I did receive some suggestions but nothing is working. I'm posting here also because I'm hoping the more eyes the better chance of resolving this. I am in a real bind here.
https://www.mrexcel.com/board/thread...ethod.1273681/

Thanks for viewing,
Steve K.

This is a VBA runtime error so I am moving your question to the VBA forum.

I do not believe this is a file problem

I get that but we have no hope of helping unless we have your file. At a bare minimum we need all of the code in the file, and an indication from you of which line of code is highlighted when the error occurs.

Thank you for including a link to the cross-post. MrExcel also requires this.

We limit Excel files to 1MB but you can zip it. We allow zip files up to 9.77MB. Don't ask me why.

I have not used AutoOpen. Instead I use Workbook_Open in the ThisWorkbook module. I'm not saying there's anything wrong with what you're doing, but I am not familiar with any quirks it may have. Have you tried disabling it (renaming it) and then manually running it once the file has fully opened?

Sheets is a collection that can contain Worksheet and Chart objects. What is Amortize? In either case, neither of those object have a method or property named cmdTitle. That's why you are getting that runtime error. I do not understand how this could have ever worked under any circumstances. Where did you get cmdTitle from, and what are you trying to do with that line of code?

OK, that should have been obvious but I wasn't thinking. So for the error to occur on that line, it appears that the runtime does not recognize the existence of the command button. Is it ActiveX? Do you have ActiveX enabled in the trust center? IN 365 Microsoft is setting the default to disabled, but that wouldn't apply to Office 2007.