Unlocking certain chart object in protected worksheet?

[Fahmi]

I have a workbook containing dynamic charts some of which are manipulated by Macro code. However, when i protect the worksheet, the code is no longer able to run. This is because the chart objects have been protected and can no longer be activated for editing. In Excel 2003 I knew of 2 simple ways to solve this problem. Firstly: by selecting the chart > right click on the Chart Area > select Format Chart Area > Properties > uncheck "Locked" tick-box. Secondly: by checking the "Edit Objects" and "Edit Scenarios" tick-boxes within the Tools > Protection > Protect Sheet dialogue box, prior to protecting the worksheet. Performing either of these two procedures allowed my charts to continue to be manipulated by my Macro code, while the remainder of the worksheet was protected from editing by third parties. But unfortunately neither of these solutions seem to work in Excel 2007. In Excel 2007 the "Format Chart Area" dialogue box does not contain a "Properties" tab, so there is no "Locked" option for me to deselect. So quite simply, how can I unlock some of my charts in Excel 2007, in order to allow them to continue to be manipulated by Macro code while applying protection to the rest of a worksheet including other charts that won't be manipulated by Macro? Any help much appreciated! Thanks.