Unlock Macro

[Former Member]

Hi Gurus

I am working on Unlock macro,

I am in process of creating two macros, one for locking (particular) KF value and second macro for unlocking KF values.

I can able to create Lock macro.

But I finding it difficult to create Unlock macro

I am using APO 3.0 system

Can any body have any suggestions?

regards

K

[Former Member]

Hi Kiran,

To create Unlock macro for the keyfigure, Please make sure you lock the keyfigure in another session and try to create the unlock.

Please let me know if you need additional details.

Thanks,

Jey

[Former Member]

Hi Kiran,

Kindly check if the note 690457 can help you.

Thanks and Regards,

Nithin.

[Former Member]

Hi Nitin

Thanks for reply.

I have checked note sent by you

I need to create macro that can be used to unlock fixed cells.

Please give some clue how to create one?

regards

K

[Former Member]

Hi Kiran,

Could you tell me version of your SCM system?.

In SCM 5.1 and above there is a possibility of unlocking fixed cells using a macro function.

In the earlier versions and also in SCM 5.1 and above, you can achieve this by just using clear_row() function in a Macro.

but make sure you clear only attributes not values, to do that double click on that particular row in your macro and choose attributes not values.

We have done similar way.

I hope it will help you.

Regards,

Srini