View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Homey Homey is offline
external usenet poster
 
Posts: 143
Default 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!?!?