SAP IBP Macros

Hello Experts,

I have issue with macros in SAP IBP Excel add-in.

I have opened location master data and started recording macros.

First step i have done is hiding columns from "C" to "H", and changed location type for some products to "P".

Then stopped recording macros and closed all Excel sheets and re-opened same master data to check the macros but unfortunately macros are erased.

can any one help me on this issue.

Br

Kumar