Can not insert a new sheet in a 2007 excel file

Hi,

Are you sharing the workbook by any chance?

When I first opened it I could add sheets without any problem, but couldn't see the macros. I was getting the 'Project is unviewable' when trying to see it in the Project Properties of the VBE, which is the message you get when the workbook is shared.

After I first made it a shared workbook, saved it, re-opened and then removed the sharing aspect the macros then became viewable.

Try experimenting with adding/removing sharing.

Regards

I hope it also worked.