S
Scampa7
I have been working on an Excel97 workbook (in NT4). This workbook has a
main sheet with various formatting added by a Worksheet_Change
procedure. This sheet is basically a database with about 60 columns and
500+ rows. There are a number of other sheets, but I have not made any
changes to these.
All had been fine until I attempted to remove a column within the data
area, and add another two columns to the left of it. I also added 4
columns at the end of the data area. When I tried to open the workbook
after saving and closing, it crashed with an 'access violation'
application error.
I have since tried removing all locked cells and protection from the
sheet, and saving again but it still crashes when I try to open it.
Any ideas on finding this problem would be very gratefully received.
Report this post to a moderator |
main sheet with various formatting added by a Worksheet_Change
procedure. This sheet is basically a database with about 60 columns and
500+ rows. There are a number of other sheets, but I have not made any
changes to these.
All had been fine until I attempted to remove a column within the data
area, and add another two columns to the left of it. I also added 4
columns at the end of the data area. When I tried to open the workbook
after saving and closing, it crashed with an 'access violation'
application error.
I have since tried removing all locked cells and protection from the
sheet, and saving again but it still crashes when I try to open it.
Any ideas on finding this problem would be very gratefully received.
Report this post to a moderator |