[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

Excel Run-Time Error '32890'

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
HaimD
Asked:
HaimD
  • 8
  • 7
1 Solution
 
Leo TorresSQL DeveloperCommented:
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
 
HaimDAuthor Commented:
Tried that...it's not the password.
0
 
Leo TorresSQL DeveloperCommented:
Is the file password protected tho??
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
HaimDAuthor Commented:
Tried all iterations...put no passwords, put no protection, etc....
0
 
Leo TorresSQL DeveloperCommented:
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
 
HaimDAuthor Commented:
No..none at all...

The link...I didn't see the connection to my problem...
Thanks
0
 
Leo TorresSQL DeveloperCommented:
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
 
HaimDAuthor Commented:
I can take it out...but then I also get the same error on:

MsgBox ActiveSheet.Name
0
 
Leo TorresSQL DeveloperCommented:
Can you post the code?? or spreadsheet
0
 
HaimDAuthor Commented:
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
 
Leo TorresSQL DeveloperCommented:
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
 
HaimDAuthor Commented:
No one is on 2007...some are on 2000
0
 
Leo TorresSQL DeveloperCommented:
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
 
HaimDAuthor Commented:
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
 
HaimDAuthor Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now