Automating Macro Execution

You can automate execution of a macro through the Smart View menu.

  To set up a macro to execute manually through the Smart View menu:

  1. Set the HypUseLinkMacro flag to false.

  2. Connect the sheet and retrieve a grid.

  3. Select a data point on the sheet.

  4. Run the macro that contains all the function calls to initialize the grid and set the connection, row, column, and POV items.