buttons

[#1]

Hi Experts,

I have a pivot table and i want to give conditional hidden.

I have a button.

Now, when i click on this button, then the chart has to get activated.

How can i do this without variables.

pls guide me...

[JoaquinLazaro]

Hi PRRAJENDRAN:

I don't understand what you're trying to do with this expression.

But maybe you should use ;

vVAR = IF (Date(MonthStart(vMaxSalesDate)) >= Today() AND Date(MonthStart(vMaxSalesDate)) <= Today(), True(), False())

Hope this helps

Joaquín