Skip to Content

Delete planning function in plan workbook

I had one query about how the deletion function should be used in plan workbook. in the plan workbook, the user would like to be able to delete the selected line / combination from plan workbook and plan cube. The options what I come up with is :

1. use macro to get the selected line in workbook and transfer the value to delete planning function (will be executed by clicking the button in workbook).

2. create another sheet, and require the user to enter the combination for which they want to delete and then get it deleted by clicking the button (delete planning fucntion will be triggered).

Could you please let me know if there is any better solution for this? And if would like to go with option 1, where I could get the sample or sample macro code?

many thanks

Jonathan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2011 at 11:47 AM

    Hi, Jonathan

    Maybe will be enough just make the key figure equal to zero and then save this value without any macros?

    Regards, Igor

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.