making current month's weeks output only

[Former Member]

Hi

We have to write a macro where we need to identify the current calendar month we are in and make all the weeks in the month read only for users. The data view we are dealing is in weekly buckets.

I see the that we have functions such as MONTH_BDATE()  and MONTH() functions but don't know how to link them.

Appreciate any suggestions.

[Former Member]

Hi K A;

Please find the below attachment how to append the two macro steps in a single macro; screen shot is pasted below.

Regards;

AravaSantosh

[former_member187047]

Hello, Maybe this blog can help you: http://scn.sap.com/community/scm/apo/demand-and-supply-network-planning/blog/2013/07/02/turn-onoff-i... Here explains how to make a key-figure or a column non editable in DP by a macro in some weeks.You can follow this logic. BR, Georgia Vanin.