Help with very strange cell behavior
Terry,
I've experienced something sort of similar to what you
describe. Namely putting the active cell into a totally
uneditable and unchangeable mode, only noticeable when
hitting Enter failed to make any changes. Usually this
could be cleared by selecting another sheet but on
occasions only by close/reopening the wb.
In my case this was triggered in a BeforeSave proc,
setting cancel to true, then activating another sheet (no
problem if selecting a cell on the original active sheet).
Apart from the beforesave I was not trapping any other
events.
In my setup this occurred every time, in others apparently
not.
The only workaround I could figure was to move
the "activate another sheet & select cell" code to a sub
in a normal module and call this from the event proc.
If you can relate this to your issue, try a similar
workaround.
Regards,
Sandy
-----Original Message-----
There is a workbook with a worksheet named "scratch" and
an assortment of
other sheets. The sheet "scratch" is hidden, all cells
locked, and
unprotected. It is always that way. It is used for all
manner of things when
a convenient place to put data from other sheets is
needed for whatever
reasons. Sorting, diddling, what have you.
From time to time in no predictable way, cell "A1"
refuses to accept any
data of any kind. You can un-hide the sheet and type
anything you want into
cell "A1". It disappears as soon as you press return or
select another
cell. Gone, vanished, non-existent, not just invisible.
Cleared out, empty.
If you delete all the cells, all the rows, all the
columns, the behavior
persists. If you go through the entire litany of locking,
unlocking,
protecting, untprotecting, etc ad nauseam it makes no
difference.
If you set a breakpoint at the Change event for this
sheet, type something
in the cell, and press return, the cell is empty at the
break. This suggests
that Excel might have a problem.
The format, color, and all that sort of stuff is
identical to the cells
around it which do no exhibit this bizarre behavior.
If you close the workbook and reopen it the cell starts
acting normally.
Then at some indeterminate time later it starts with the
inexplicable
behavior. During this time the sheet may have been
cleared and/or all the
cells deleted any number of times and eclectic
collections of stuff have
been placed on it, by pasting and/or simply setting
values. None of the
stuff put there is abnormal in any way. Just all of
sudden this cell refuses
to contain anything.
It may well be something I'm doing but I haven't a clue
just what it might
be.
--
Terry
"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley
.
|