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

    How to run a Macro when opening opening a sheet.

    thodoris voulelis

      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?