It's probably not related to your problem, but when I try to run this I get a problem in a different place. You're opening [Try this.xlsm], but when I download it and save it, its name is [Try this.xlsx].



I tried renaming the downloaded workbook as [Try this.xlsm], but Excel balked; it says "Run-time error '1004' / Application-defined or object-defined error". So I tried again by changing the name in the program to [Try this.xlsx]. That opened the workbook just fine, and then consented to save it as [Try this 1.xlsm]. But I didn't get your problem with the last statement, either.

Before I give up, let me try asking questions from another angle: Where are you when you run the "test" macro, and what process do you use to invoke it? Which workbook and sheet is active, what keystrokes or clicks do you use, etc?

Oh, and let's have a better description of the error, too. "Microsoft Visual Basic box with just 400" doesn't convey the right picture to me.

I am using the test.xlsm document to open the file try this. It then saves it in a new directory and tries to remove the sheet password to perform edits. I have attached a screenshot of the error. Nothing more that i stated i'm afraid.

Attached Files

Doc1.docx (134.6 KB, 10 views)

Wow, you weren't kidding! I assumed there was text along with that error.

I did a little googling and found these references. Maybe one will help:

http://www.add-ins.com/support/micro...-error-400.htm

http://social.msdn.microsoft.com/For...p?forum=isvvba

http://www.excelforum.com/excel-prog...-400-mean.html

http://excel.questionfor.info/q_micr...el_141010.html (this one has a list of a dozen or so links to similar-sounding questions)

I didn't read them all carefully (just enough to see that there were some suggestions in each about what to do), but I notice that at least two say it may have to do with an add-in that needs to be fixed, perhaps uninstalled and reinstalled. That would go along with the fact that two of us couldn't reproduce the error on our own machines.