I have a Workbook in Analysis for Office based on a query that expands the master data of a characteristic in the column. I have to show only some elements of this characteristic (ie I have to hide some columns of the workbook).
The workbook opens showing the query prompt it is based on. After entering the variables and pressing the "Ok" button of the prompt, I have to hide some columns so that they are not visible to the user.
Can anyone help me on how to call a macro after hitting the "Ok" button of the prompt?