Developed several macros in Excel 2007 and saved them in the Personal.xls workbook so they could be used in all my spreadsheets. The macros have been working fine. All of a sudden I noticed that the only option available was the run and cancel functions. One of the macros has to be edited / changed for each month it is run. It I call up the VBA editor, it says "project not viewable" if the project containing the macros is selected. I never put any security on any macros and the VBA editor does not ask for a password when I try and access the project.

It appears that this project became corrupt somehow and has some type of security involved. I can recreate the macros if necessary. Is there any way to get rid of the existing macros? Can the Personal.xls workbook be deleted and if so, how does it need to be recreated to serve as a workbook for macros accessiable for all spreadsheets.