You can't from VBA. You can use callback code to set the label, but that callback is invoked when the ribbon starts up. You cannot change it from some Excel event I am afraid.
You can't from VBA. You can use callback code to set the label, but that callback is invoked when the ribbon starts up. You cannot change it from some Excel event I am afraid.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber