Can't view password protected code

y2k · Apr 5th, 2002, 05:06 AM

I have a file which contains some VBA. I password protected it so that nobody could change it. When I tried to view the code on somebody else's PC, I got an error that the project was unviewable, it didn't prompt me for the password. Why? I need to do this on somebody else's PC as they need to specify a password contained in the code for protecting the workbook and I don't want to know the password they're going to be using. So they need to enter it.

Please help... anybody

Mark O'Brien · Apr 5th, 2002, 07:43 AM

One reason could be that you protected the code using XL 2000 (or higher) and tried to view it using XL 97. 97 used a different encoding system for VBA password protection (for "different", read "weaker") I believe that XL 2000 has the backward compatability to use the XL97 system, but not vice versa. I really hope this makes sense, I'm tired.

Apr 5th, 2002, 07:43 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	One reason could be that you protected the code using XL 2000 (or higher) and tried to view it using XL 97. 97 used a different encoding system for VBA password protection (for "different", read "weaker") I believe that XL 2000 has the backward compatability to use the XL97 system, but not vice versa. I really hope this makes sense, I'm tired. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Apr 5th, 2002, 05:06 AM	#1
y2k Board Regular Join Date: Feb 2002 Location: Ireland Posts: 133	I have a file which contains some VBA. I password protected it so that nobody could change it. When I tried to view the code on somebody else's PC, I got an error that the project was unviewable, it didn't prompt me for the password. Why? I need to do this on somebody else's PC as they need to specify a password contained in the code for protecting the workbook and I don't want to know the password they're going to be using. So they need to enter it. Please help... anybody