disappearing ActiveX controls
 

Hi

Has anyone had any experience of command buttons 'disappearing' as macro
code is running (updating a set of pivot tables on the same sheet as the
button, before setting the 'disappearing button' caption to reflect the pivot
page items), leading to 'object has been deleted' or 'object has disconnected
from its client' errors?

This spreadsheet has worked fine for months, so any help in identifying what
may be causing this new behaviour will be massively appreciated.

Paul