Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing password
All
A few years ago I wrote a programme along with a few colleagues, we used a common password between us. I left the department on promotion and have just returned to a different department. Since I have been gone, the programme has been developed with a few bells and whistles attached but it is basically the same. I have been asked to investigate a few problems with it and I need to change the password (It is still the old one). I have been through all the relevant sheets and vba and changed the passwords OK, but the programme gives me a " compile error in hidden module mdnew333". I sometimes get compile error 13 too. I have changed absolutely nothing other than the pw. Are there some hidden files I've missed? TIA Richard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing password
Do you have a module named mdnew333 in that workbook's project?
If yes, try unprotecting the project and compiling the code. If no, look at the other open workbook projects for a module named mdnew333. Charlie Brown wrote: All A few years ago I wrote a programme along with a few colleagues, we used a common password between us. I left the department on promotion and have just returned to a different department. Since I have been gone, the programme has been developed with a few bells and whistles attached but it is basically the same. I have been asked to investigate a few problems with it and I need to change the password (It is still the old one). I have been through all the relevant sheets and vba and changed the passwords OK, but the programme gives me a " compile error in hidden module mdnew333". I sometimes get compile error 13 too. I have changed absolutely nothing other than the pw. Are there some hidden files I've missed? TIA Richard -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing password
Dave
Yes I can see the module mdnew333 OK but I can't see anything wrong with it. BTW, this programme is running on a server, on a standalone machine, everything works fine. Charlie "Dave Peterson" wrote in message ... Do you have a module named mdnew333 in that workbook's project? If yes, try unprotecting the project and compiling the code. If no, look at the other open workbook projects for a module named mdnew333. Charlie Brown wrote: All A few years ago I wrote a programme along with a few colleagues, we used a common password between us. I left the department on promotion and have just returned to a different department. Since I have been gone, the programme has been developed with a few bells and whistles attached but it is basically the same. I have been asked to investigate a few problems with it and I need to change the password (It is still the old one). I have been through all the relevant sheets and vba and changed the passwords OK, but the programme gives me a " compile error in hidden module mdnew333". I sometimes get compile error 13 too. I have changed absolutely nothing other than the pw. Are there some hidden files I've missed? TIA Richard -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing password
How about making a test version of the workbook, unprotect that workbook's
project and see where the debug option takes you. (I don't have a guess about running from a server, though.) Charlie Brown wrote: Dave Yes I can see the module mdnew333 OK but I can't see anything wrong with it. BTW, this programme is running on a server, on a standalone machine, everything works fine. Charlie "Dave Peterson" wrote in message ... Do you have a module named mdnew333 in that workbook's project? If yes, try unprotecting the project and compiling the code. If no, look at the other open workbook projects for a module named mdnew333. Charlie Brown wrote: All A few years ago I wrote a programme along with a few colleagues, we used a common password between us. I left the department on promotion and have just returned to a different department. Since I have been gone, the programme has been developed with a few bells and whistles attached but it is basically the same. I have been asked to investigate a few problems with it and I need to change the password (It is still the old one). I have been through all the relevant sheets and vba and changed the passwords OK, but the programme gives me a " compile error in hidden module mdnew333". I sometimes get compile error 13 too. I have changed absolutely nothing other than the pw. Are there some hidden files I've missed? TIA Richard -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing password in Excel workbook | Excel Worksheet Functions | |||
changing a password protected file | Excel Discussion (Misc queries) | |||
Restrict users from changing password | Excel Discussion (Misc queries) | |||
Prevent users from changing the password | Excel Discussion (Misc queries) | |||
Changing password protection on sheets | Excel Discussion (Misc queries) |