Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project not viewable
I have a file at work that I wrote macros and password protected the file and
the VBA. I copied the file to my home computer and I can open the file ... and then it says "Could not load an object because it is not available on this machine." Also "Compile error in hidden module: This Workbook ... this one is expected becuase there is code specific to a work setup that would have to be ammened to work at home. When I try to go to the VBA code it says "Project is unviewable." What causes that and how can I setup the file at work so I will be able to take it to another machine and see the code. Note: I have other files which are password protected on the VBA that I am able to enter the password and get to the modules. Thank you for your help. Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project not viewable
In what version of Excel were the files originally created and the
code protected? I forget the details, but there was a problem opening modules protected in a version other than the one under which the code was originally protected. I vague memory serves, the problem was between Excel 97 and Excel 2000. Also, such a problem could be caused by opening files created in USA versions in non-USA version (because the encryption in some non-USA versions was weaker than in USA versions). I doubt this last problem in the cause of what you are seeing. If possible, open the file on the same machine or at least in the same version of Excel as which it was created. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 24 May 2009 13:08:00 -0700, Steven wrote: I have a file at work that I wrote macros and password protected the file and the VBA. I copied the file to my home computer and I can open the file ... and then it says "Could not load an object because it is not available on this machine." Also "Compile error in hidden module: This Workbook ... this one is expected becuase there is code specific to a work setup that would have to be ammened to work at home. When I try to go to the VBA code it says "Project is unviewable." What causes that and how can I setup the file at work so I will be able to take it to another machine and see the code. Note: I have other files which are password protected on the VBA that I am able to enter the password and get to the modules. Thank you for your help. Steven |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project not viewable
Just to add to Chip's response...
You can get that message if the workbook is shared, too. Steven wrote: I have a file at work that I wrote macros and password protected the file and the VBA. I copied the file to my home computer and I can open the file ... and then it says "Could not load an object because it is not available on this machine." Also "Compile error in hidden module: This Workbook ... this one is expected becuase there is code specific to a work setup that would have to be ammened to work at home. When I try to go to the VBA code it says "Project is unviewable." What causes that and how can I setup the file at work so I will be able to take it to another machine and see the code. Note: I have other files which are password protected on the VBA that I am able to enter the password and get to the modules. Thank you for your help. Steven -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROJECT NOT VIEWABLE? | Excel Discussion (Misc queries) | |||
text not viewable | Excel Discussion (Misc queries) | |||
Viewable columns | Excel Discussion (Misc queries) | |||
VBA Project Not Viewable | Excel Programming | |||
Picture is not viewable | Excel Discussion (Misc queries) |