ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel crash (https://www.excelbanter.com/excel-programming/421640-excel-crash.html)

Fan924

Excel crash
 
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

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


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com