Den 2006-06-15 12:52:12 skrev Johnny Andersson <[EMAIL PROTECTED]>:
I have a not so big spreadsheet (OpenOffice.org Calc 1.1.5) and I though
of creating a macro which looks in certain cells for bad values and
correcting them. My thought is that every time I enter something in a
cell, the macro looks in it and corrects it if necessary.
The "dream" is that I can assing every change in a specific cell to a
macro, for example when I change the value in C3 and press Enter, a
macro will start checking and, if necessary, correct the value in C3.
However, when I looked around I couldn't find out how to do this. All I
could find was that I could make it start a macro when I save the
spreadsheet and things like that, not when changing a specific call.
I mean "cell" of course, not "call"... sorry for that. I don't know how
that happened... ;)
Is this impossible or did I miss something? If not possible in 1.1.5, is
it possible with 2.0?
--
Johnny
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
