VBA Module Not Viewable
 

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!?!?

VBA Module Not Viewable
 

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.


"outsol" wrote in message
...
| 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!?!?

VBA Module Not Viewable
 

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?!?

"Homey" wrote:

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.


"outsol" wrote in message
...
| 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!?!?