How to run a Macro when opening opening a sheet.

[#1]

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?

[fernandotoledo]

You can do it by using ACTIONS. It´s quite intuitive, and you can access them through Document, Sheet and some objects like Buttons and Text Box Properties.

[#3]

Actualy I worl on the 8.5 version...

So I cant see the actions operation..OR i am doing something wrong. 😞