2 Replies Latest reply: Jan 21, 2011 7:34 AM by thodoris voulelis RSS

    How to run a Macro when opening opening a sheet.

      Hello everybody


      I have a qvw with 3 sheets

      my Sheet1 is the filters (the filter is a simple table with a list of colors.


      and sheet 2 - 3 are the data(sheet2 - sheet3)


      What I want is to create a macro "poropably" on the sheets (2&3) properties and propably on (ONActivateSheet)

      to apply a filter on the table that exists on Sheet1 (filters)


      Example. when I select to see Sheet2 then in Sheet1 in tableA the system should pick the color "green" from the list of colors inside the table data....

      anybody know how can I write this Macro?