So I develop an application "desktop' which is VERY dependent on a Pivot table being Detached and then Attached, triggered by Sheet activation events. Specifically the Pivot table is a clickable grid, If it is attached and a grid cell is clicked, the table will collapse horizontally and vertical because the clicked cell becomes a filter. To prevent this I Detach the Object so I does not respond to the selection, but other objects will. We move the application to the Sever side and I find out that Macros are not supported, but can be approximated via Extensions. So I hunt around for extensions and cannot find this functionality.
Any advise ?
Terence
I have considered writing the extension myself, this would be an Object extension, not a Document extension.
