Problems transferring macro to Excel 2007

[SiddersAtCHEP]

Hi

Can anyone help with this. I have some macro code developed in 2003 which doesn't seem to work in 2007.

This routine is called and I pass over the TopAdd and BottomAdd

Sub MakeProdList(TopAdd, BottomAdd)
MyListFillRangeString = "'Priced GTL v2.0'!" & TopAdd & ":" & BottomAdd
Sheets("Activity Breakdown").cbxProdList.ListFillRange = MyListFillRangeString
Sheets("Charge Summary").cbxChargeSum.ListFillRange = MyListFillRangeString
Sheets("Amended_Rejected Transactions").cbxAmendReject.ListFillRange = MyListFillRangeString
Sheets("Activity Summary").cbxActSum.ListFillRange = MyListFillRangeString
End Sub

You can see that this creates a string that I want to put into the ListFillRange property of a combo box. On each of the sheets, I use the code that works perfectly well in 2003 but in 2007, it does not change the ListFillrange property to the required data.

In fact, when I go into the combo box manually and get the properties box showing, it won't let me edit the ListFillrange. Actually, I also tried editing the LinkedCell property and the moment I pressed <Return> it blanked that box out as well. So, in effect, I do not seem to be able to edit these values.

Why?!

What would I need to do to rectify this?

Many thanks to anyone who can point me in the right direction.

Sidders