View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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