Macro - Unable to view Macro Properties to Unlock Project

Bryan from CT

New Member
Joined
Oct 13, 2002
Messages
4
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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
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

New Member
Joined
Oct 13, 2002
Messages
4
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

New Member
Joined
Oct 13, 2002
Messages
4
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

New Member
Joined
Oct 13, 2002
Messages
4
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
 

Forum statistics

Threads
1,144,510
Messages
5,724,773
Members
422,577
Latest member
kayth891

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top