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

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!!
 
D

Dave Peterson

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.
 
J

jow77

Excellent!! Thanks so much!! Appreciate the help and
certainly the quick response!! Just saved me hours of
weekend work. thanks again!!!
 
Top