Macro - Unable to view Macro Properties to Unlock Project

[Bryan from CT]

When I try to view a macro to edit it, it comes up with the message "Project is unviewable". I am unable to view the properties of the macro to unlock it. How do I view the macro to edit it. Thanks.

Bryan

 

[XL-Dennis]

Bryan,

One explanation may be that the workbook was locked & saved in a newer version of XL than You now trying to open it in, i e saved in XL 2000 and You´re trying to unlock it in XL 97.

If so, the only way to unlock the vba-project is to open it in the newer version of XL.

Kind regards,
Dennis

 

[Bryan from CT]

If this was done using Office 2000, why would I be able to open any of this in Office 97. I will try this route but could there be something else. Thanks.

Bryan

 

[Bryan from CT]

Thanks, that was exactly it. I just had to find someone in our company that had Excel 2000 and everything lit up. Thanks again.

-Bryan

 

[Bryan from CT]

Thanks, that was exactly it. I just had to find someone in our company that had Excel 2000 and everything lit up. Thanks again.

-Bryan