hidden VBA

[scottnshelly]

a very advanced coder at my work has written up an excellent workbook.
the VBA code is unviewable. when i click the design mode button, th
'view code' button is grayed out. when i get to the visual basi
editor by alt+11 and click on the workbook i get a message that thi
says 'this project is unviewable'
how can i do this and better yet, how can i undo this

 

[Rob Bovey]

Hi Scott,

It sounds like you're using Excel 97 and he's using a later version of
Excel. MS changed the VBProject protection algorithm between Excel 97 and
Excel 2000, so Excel 97 can't unprotect VBProjects that have been protected
in any later version of Excel. All versions of Excel after 97 use the same
algorithm, though, so they can all open each others protected projects.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[pauluk]

heres some info

If you use Excel 97 or later... Activate the VB Editor and select you
project in the Projects window. Then choose Tools - xxxx Propertie
(where xxxx corresponds to your Project name). In the Projec
Properties dialog box, click the Protection tab. Place a checkmark nex
to Lock project for viewing, and enter a password (twice). Click OK
then save your file. When the file is closed and then re-opened,
password will be required to view or modify the code.

to find out if has a password protection and to break it download
file called passware it can break some passwords if you have forgo
the

 

[scottnshelly]

I appreciate your responses. I am using XP and he is using 2000.
have also tried to do this on 2000 to no avail.
i tried going to tools - but it says the project is unviewable.
he told me the password, but i can't find the prompt to enter it

 

[pauluk]

press Alt +f11
press Ctrl+r

now double click on the project it should ask for a password

 

[Rob Bovey]

Hi Scott,

This should definitely work. It sounds like there might be something
wrong with your Excel installation. Do have another computer that you can
use to create a test project that's password protected and check to see if
you can open it on your machine? Are you able to password-protect your own
projects and open them?

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Letsride]

Sounds like this is a shared workbook. Tools>Shared
workbook>uncheck>ok out.

 

[adamz5]

Hi Scott can you forward it on-- i can have a look

Cheers Adam
(e-mail address removed)

 

[scottnshelly]

Thanks.
I asked the author and we together figured out that it was becuase i
was shared. thanks for your help