Avatar of HaimD

asked on 

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.
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon