Remove password from workbook in xla

Herman · Mar 20th, 2002, 11:39 AM

I have an xla which is password protected,
i know the password so i can look at the code.but i have a workbook in it which is also protected with a password and i don't know this one.
How can i open this workbook (the properties of isaddin are set to yes)

thanx in advance

Jack in the UK · Mar 20th, 2002, 02:57 PM

I have an xla which is password protected,
i know the password so i can look at the code.but i have a workbook in it which is also protected with a password and i don't know this one.
How can i open this workbook (the properties of isaddin are set to yes)

XLA are extreamly hard to crack, i guess the module is view protected password this can be broken, with a suggested password, im not saying its correct just a suggestion, a shot in the dark, but it will open the module ans give a suggested password that will do just this. i have some VBA code to do this, if intrested email me and ill dig it out and mail to you...

Email on my profile...

BTW search this board, i and many others have covered this in details, some good ideas codes all sorts

connect · Oct 14th, 2009, 03:05 PM

Hello Jack,

I have an xla protected with a password (created by a former employee who apparently didn't want to share their creative genius...)

Do you have VBA code that might help me to open the XLA?

Thank you,

Mar 20th, 2002, 02:57 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	I have an xla which is password protected, i know the password so i can look at the code.but i have a workbook in it which is also protected with a password and i don't know this one. How can i open this workbook (the properties of isaddin are set to yes) XLA are extreamly hard to crack, i guess the module is view protected password this can be broken, with a suggested password, im not saying its correct just a suggestion, a shot in the dark, but it will open the module ans give a suggested password that will do just this. i have some VBA code to do this, if intrested email me and ill dig it out and mail to you... Email on my profile... BTW search this board, i and many others have covered this in details, some good ideas codes all sorts __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Oct 14th, 2009, 03:05 PM	#3
connect New Member Join Date: Oct 2009 Posts: 1	Re: Remove password from workbook in xla Hello Jack, I have an xla protected with a password (created by a former employee who apparently didn't want to share their creative genius...) Do you have VBA code that might help me to open the XLA? Thank you,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 11:39 AM	#1
Herman New Member Join Date: Feb 2002 Posts: 28	I have an xla which is password protected, i know the password so i can look at the code.but i have a workbook in it which is also protected with a password and i don't know this one. How can i open this workbook (the properties of isaddin are set to yes) thanx in advance