Hi -
I'm building an App where the User's Wbk is referenced to an Addin.
A 'parm' sheet in the user's wbk has a sheet change event macro.

call MgrEdit(target.address) ' the edit macro is in the addin

Changing ONLY the font color of a cell does not seem to fire the change
event.
I'm looking for a way to crank up the edit immediately after the user clicks
the desired color in the standard palette.

It's a little screwy, but I need to edit the
cells(row,col).font.colorindex after I convert the $a$28 to row and col
values(which is working nicely).

I know that I can:
1. Ask the user to change the text value in the 'color' cell after
changing the color, but that also has a meaning in the app, and the user
would then have to change the text back to the 'really' desired text value.
Simple for me, but "klugy" to the user.

2. Build a macro that controls the font color selection and fire the edit
after the selection. 2a. Build another Menu entry the user would select
after changing only the font color of the cell. Both seem like overkill.

3. Edit the value when the 'next' macro is run by the user. Inconsistant
with the way the other cells are treated 'parm' sheet 'real' value
changes when the edit does fire on a change.

Is there a more straight forward way?

Thanks,
Neal Z.







--
Neal Z