msg box and or sheet events
I want to trigger an event by changing the format(we
change the fill colour) of a cell.The change event isnt
triggered by changing the fill colour.Other wise i can
prompt the user with a msg box to select a range but excel
is frozen while the msgbox appears.
|