Thread: Excel crash
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel crash

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.

Fan924 wrote:

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


--

Dave Peterson