Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!?!? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!?!? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!?!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA project not viewable | Excel Programming | |||
PROJECT NOT VIEWABLE? | Excel Discussion (Misc queries) | |||
text not viewable | Excel Discussion (Misc queries) | |||
VBA Project Not Viewable | Excel Programming | |||
Picture is not viewable | Excel Discussion (Misc queries) |