Hi,
I got a spreadsheet which is doing a really strange thing.
The sheet is full of macros and some under the Worksheet_Change event but I have if statements to only run the code if certain cells are changed.
Now when the workbook is unshared and I delete rows 1000 to 65536 everything happens as fine, the rows are deleted.
When the workbook is shared and I do the same thing excel goes in to some never ending loop where the sheet looks like its deleting those rows over and over (I think, I don’t really know what its doing)
I can delete 1 row fine and I can delete several rows fine its just when I from 1000 to the end row.
Any ideas what could be causing this?
I got a spreadsheet which is doing a really strange thing.
The sheet is full of macros and some under the Worksheet_Change event but I have if statements to only run the code if certain cells are changed.
Now when the workbook is unshared and I delete rows 1000 to 65536 everything happens as fine, the rows are deleted.
When the workbook is shared and I do the same thing excel goes in to some never ending loop where the sheet looks like its deleting those rows over and over (I think, I don’t really know what its doing)
I can delete 1 row fine and I can delete several rows fine its just when I from 1000 to the end row.
Any ideas what could be causing this?