Excel Run-Time Error '32890'

Is this file password protected if so remove the password protection and try again..

If it not password protected then you may want to remove this line of code

Tried that...it's not the password.

Is the file password protected tho??

Tried all iterations...put no passwords, put no protection, etc....

OK but that still does not answer my question..

Does The spreadsheet in question have any form of password protection?? On Workbook, worksheet or column or row that is the question..  Once we determine that then we can revisit possible reasons..



If there is a password protection on the file some where see this:
http://able2know.org/topic/9295-1

No..none at all...

The link...I didn't see the connection to my problem...
Thanks

OK then yes if there is no password then there is no relation..

from your post looks like your on 2003..

I cant see then why you would need to have this line of code
ActiveSheet.Unprotect

if there is no password in your file anywhere..

Can you comment out this line run the code and pst the error its gives you if any

I can take it out...but then I also get the same error on:

MsgBox ActiveSheet.Name

Can you post the code?? or spreadsheet

It's very lengthly and the file is heavy with links to other workbooks and queries from company database.  Won't work...

Ugh...

HOWEVER, I now have eliminated the run-time errors (by changing the Control toolbox Button to a Form  Button).

Really, what's going on is that the forms control button I  have placed in the cell of a file gets deleted at some point (by others users experiences) and that my data validation no longer has drop-down (although the Input Message still appears).  I cannot duplicate my user's errors.

I have a feeling it may be the Excel versions that they are using.


Before-Error.JPG
After-Error.JPG

Are you saying that this form was coded in 2003 but some of your users are using 2007... That could be it.. I was under the impression that everything was 2003..

No one is on 2007...some are on 2000

If they the columns move yes, the box may be referencing that has moved..  

Can you check Under Data validation and see where the box is pointing to?? I have 2007  dont remember where it is in 2003..
See if its pointing to where its supposed to be pointing to

ltorres321...

Thanks for all your help, but this isn't going down the right path at the moment.  I have 2 open questions, of similar nature, but I must close them and re-post new, yet simpler problems.

Simply put, the workbook gets seriously corrupted by deleting the button and "half" of the data validation (you can see from the pixs above)....

I just want to answer this question, so I'll be re-posting momentarily if you want to follow that thread...

Thanks again