Solved

Excel Run-Time Error '32890'

Posted on 2010-09-08
15
381 Views
Last Modified: 2012-05-10
The weirdest thing:

I am getting an error on this line of VBA code:

ActiveSheet.Unprotect passSh '[whereas passSh is the password] - password is accurate

I cannot even execute this line without the similar 32890 error!:

MsgBox ActiveSheet.Name

I also cannot execute in the immediate window either:

? ActiveSheet.Name

This all happens after I get an errored file whereas the control button I've added gets deleted and all the data validation gets wiped out.
0
Comment
Question by:HaimD
  • 8
  • 7
15 Comments
 
LVL 8

Expert Comment

by:Leo Torres
ID: 33630305
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
0
 

Author Comment

by:HaimD
ID: 33630316
Tried that...it's not the password.
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 33630337
Is the file password protected tho??
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:HaimD
ID: 33630364
Tried all iterations...put no passwords, put no protection, etc....
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 33630456
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
0
 

Author Comment

by:HaimD
ID: 33630595
No..none at all...

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

Expert Comment

by:Leo Torres
ID: 33630729
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

0
 

Author Comment

by:HaimD
ID: 33630738
I can take it out...but then I also get the same error on:

MsgBox ActiveSheet.Name
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 33630952
Can you post the code?? or spreadsheet
0
 

Author Comment

by:HaimD
ID: 33631093
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
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 33631140
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..
0
 

Author Comment

by:HaimD
ID: 33631166
No one is on 2007...some are on 2000
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 33631247
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
0
 

Author Comment

by:HaimD
ID: 33631600
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
0
 

Accepted Solution

by:
HaimD earned 0 total points
ID: 33631622
This particular error is resolved by switching the button from a Control Toolbox Button to a Form Button.  However, I now have new and different errors.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now