El Matarife
New Member
- Joined
- Mar 18, 2009
- Messages
- 2
I have a workbook containing dynamic charts that are manipulated by Macro code. However, when you protect the worksheet that those charts are on, 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 in question > 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.
Also, despite checking the "Edit Objects" and "Edit Scenarios" tick-boxes in the "Protect Sheet" dialogue box, my Macro code is still unable to manipulate the charts and being is prevented from running by Excel. Contrary to what Microsoft imply under point 9 (Worksheet Elements) here: http://office.microsoft.com/en-us/excel/HA100968371033.aspx
So quite simply, how can I unlock 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?
Many thanks for any help!
In Excel 2003 I knew of 2 simple ways to solve this problem. Firstly: by selecting the chart in question > 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.
Also, despite checking the "Edit Objects" and "Edit Scenarios" tick-boxes in the "Protect Sheet" dialogue box, my Macro code is still unable to manipulate the charts and being is prevented from running by Excel. Contrary to what Microsoft imply under point 9 (Worksheet Elements) here: http://office.microsoft.com/en-us/excel/HA100968371033.aspx
So quite simply, how can I unlock 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?
Many thanks for any help!
