You need to create a public variable, and set that when the calculate macro starts and unset it at the end. Your listbox code then checks this variable, and exits quietly if set.
You need to create a public variable, and set that when the calculate macro starts and unset it at the end. Your listbox code then checks this variable, and exits quietly if set.
____________________________________________
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
Posting Permissions
Reply With Quote