VBA Module Not Viewable

O

outsol

Excel 2007

I developed a module that worked and decided on a Friday to "protect" it
until it was fully tested. I added a password to the module which I used
successfully several times. Backing out of the project I must have selected
some other protection parameter incorrectly because on Monday, I did not get
the password prompt and the module says it is not viewable. Please help! I
can't get to the permissions of the project to correct the password. it says
the VBAProperties are not viewable either. What did I do!?!?
 
H

Homey

maybe you not do thjis but if you choose 'share workbook' on review tab you
can no more see the vb code. you have to unshare it first.


| Excel 2007
|
| I developed a module that worked and decided on a Friday to "protect" it
| until it was fully tested. I added a password to the module which I used
| successfully several times. Backing out of the project I must have
selected
| some other protection parameter incorrectly because on Monday, I did not
get
| the password prompt and the module says it is not viewable. Please help! I
| can't get to the permissions of the project to correct the password. it
says
| the VBAProperties are not viewable either. What did I do!?!?
 
O

outsol

Thank you so much Homey. That worked! I had been lookin for "unshare" because
MS called "protect/unprotect" so logic says "share/unshare" right? No after
your post I found it under "Stop sharing a workbook" which makes sense after
you know what you are looking for. Perhaps MS could keyword "unshare" on this
topic?!?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top