Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Actualy I worl on the 8.5 version...
So I cant see the actions operation..OR i am doing something wrong. 😞