View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scampa7[_6_] Scampa7[_6_] is offline
external usenet poster
 
Posts: 1
Default Excel97 workbook crashes after changes to columns


I am working on an Excel97 workbook (in NT4). There are various macros
associated with this workbook and the main sheet has formatting which
is put on the sheet by a Worksheet_Change procedure.

This has been working normally, until I attempted to remove a column
within the sheet and add another inside the main data area. I also had
added 4 columns at the end of the sheet. After adding the columns I
saved and closed file. When I tried to open again I get a Dr Watson
application error - access violation.

I have repeated this, unlocking all the cells and removing all the
protection from the sheet, but it still crashes when I try to open it.

Iwould be very grateful of any ideas of what I could try.

thanks,


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/