not possible to insert charts causes errors in my app

[aretai]

I'm working on some simple application that inserts charts based on data. Data I receive in a worksheet and graph is to be based on them. For some reason however my code (which works just fine in a test worksheet created by me) doesn't work (it breaks at the second line):

Dim ch As ChartObject
Set ch = ActiveSheet.ChartObjects.Add(100, 30, 400, 250)

I'm relatively new to Excel 2007 and I've noticed that on the insert tab in the test worksheet is is possible to insert graphs by pressing a button. However on the data I receive these icons are inactive grey. Does it really matter and well how can I make it work?

Thank you

[romperstomper]

With one of those workbooks open, open the Excel Options, select the Advanced section, then under (I think) the Display section there should be an option relating to showing objects - make sure it's set to show all.

[aretai]

With one of those workbooks open, open the Excel Options, select the Advanced section, then under (I think) the Display section there should be an option relating to showing objects - make sure it's set to show all.

there is no Advanced section in Excel 2007 - there are tabs home, insert (here are the graphs), page layout, formulas, data, review, view, add-ins.

[romperstomper]

I guess you missed the bit where I said to open the Excel Options first? (Office button, 'Excel options...' in the bottom right corner)

[aretai]

No I'm simply v.new to Excel 2007. I have checked and even if both worksheets (test and the one I'm working on) have the same configuration in options I'm still not able to insert any charts in the target worksheet. I thought that maybe it is somehow protected against inserting charts or something. I can edit the data itself though.

[romperstomper]

I assume it's not a shared workbook and that you don't have multiple sheets selected?
With the relevant workbook active, can you post a screenshot of the section in the options dialog that I mentioned?

[aretai]

thx for your help it seems that the sheet was protected (as I thought but didn't know where to look for it in Excel 2007) Once I removed the protection from the sheet I'm now able to insert graphs.