macro for vendor calendar

[Former Member]

Hi guys,

Regarding one macro requirement is, According to vendor calendar holiday list the Distribution Receipt (planned) & Production (planned) keyfigure in the planning table 'cells' should be u201Cgrayu201D mode .

Eg:- Suppose Vendor calendar have being holiday on saturday (19.09.2009), sunday (20.09.2009).

It means for these days, the Distribution Receipt (planned), Production (planned) keyfigures 'cells' should be u201Cgrayu201D mode.

can any one help me out...

thanks in advance.

regards,

kumar

[Former Member · Accepted solution]

Hi Kumar

You should be able to get it with function BUCKET_WDAYS()

If the result is 0 ofr a specific bucket, then you do not have any working day in this bucket.

Then you can close the bucket with CELL_INPUT() and change the color with CELL_BG().

I hope it helps

Regards

Julien