i have created a sheet in my report and in that sheet i have used multiboxes,pivot tables etc. i have used a pivot table to create a calender. multibox has been used as a selection box for the user to select various parameters of the reports. now whenever a user selects a parameter from the multibox the calender automatically gets activeted and only active values are shown in the calender.
i want it to remain in its original size and shape even after a selection is made. how can i achieve that???