Excel crash

F

Fan924

When I open a workbook and then click save, a sheet tab apears that
says module2. If I click on the tab, excel locks up. What can I do to
make this go away? Excel 97
 
D

Dave Peterson

In xl95, the VBA code was kept in special sheets (module sheets). xl97 was the
first version to have the VBE (where your code resides now).

This is a guess...

But I'd start by recreating the workbook.

Select all the worksheet tabs and copy them to a new workbook. Make sure you
copy any code modules, too from the old project to the new project, too.

Then test out this new workbook.
 
Top