S
Scampa7
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,
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,