Solved

Excel Run-Time Error '32890'

Posted on 2010-09-08
15
378 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
 

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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

758 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

19 Experts available now in Live!

Get 1:1 Help Now