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?