Attempting to open Project VBA--"Project is Unviewable"

  • Thread starter Thread starter Jow77
  • Start date Start date
J

Jow77

Unable to get Project module unlocked nor able to edit
macro in a network-shared spreadsheet, even though owner's
machine was used to create the macro and then later edited
with VBA. When clicking on the Project a pop-up dialog box
with "Project is Unviewable". Any workarounds? Excel help
files no use---cannot get to the Project properties
protection tab!!
 
If the workbook is really shared (tools|share workbook), then you'll have to
unshare it first.

If the workbook isn't shared (just common), then maybe the project was protected
in xl2k (or higher) and you're trying to open it in xl97.

If that's the case, unprotect the workbook in xl2k (or higher) and remove the
password. Then xl97 can open up that project.
 
Excellent!! Thanks so much!! Appreciate the help and
certainly the quick response!! Just saved me hours of
weekend work. thanks again!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top