Excel 2007 vs Excel 2003

[occam]

I have a basic question. (Running Microsoft Excel 2007 on an XP SP3 machine) I am using an Excel file with macros. The file is 'macro enabled', but when I click on a specific button (non-Microsoft) within the spreadsheet, I get a Microsoft Visual Basic Error : " run-time error '1004' Select method of Range class failed " I have contacted the (government) department issuing this mandatory form. Their diagnosis is "This is a Excel version issue. Use Excel 2003, not 2007" ! I am stumped! I upgraded to MS Office 2007 some time ago, and have no access to earlier versions. I have tried to create "Compatible Mode" versions of the file (compatible with Excel 97-2003 workbook) but still the same error. Question 1 - is their diagnosis correct? Question 2 - If not, is there a work-around? Thanks for /any/ pointers. occam

 

[occam]

In Controls click Design Mode, then right click the button. Do you see a menu?

Yes, four choices 1- Add to Quick Access Toolbar 2- Customise QAT... 3- Show QAT below Ribbon 4- Minimize the ribbon

 

[Andrew Poulsom]

Is this button on the worksheet or on a Toolbar?

 

[occam]

Is this button on the worksheet or on a Toolbar?

Sorry, if by 'this button' you mean the one causing the problems.. this is a custom made button in the worksheet. It is supposed to allow me to add a 'new participant' slot, on a list of participants. And the correct answer to your question is there a menu when you "right click this button" - is 'No'. The custom button does not reveal any menus when 'right clicked'

 

[Andrew Poulsom]

So if you right click it in Design mode do you see a menu containing Properties? Or if you click it in Design mode and click Properties on the ribbon, do you get a Properties window?

 

[occam]

So if you right click it in Design mode do you see a menu containing Properties?

I'm afraid not.

Or if you click it in Design mode and click Properties on the ribbon, do you get a Properties window?

Again, no. I'm sorry Andrew, I seem to be taking up a lot of your time. I'll approach the EC department in question again and get them to sort it out. thanks, occam

 

[priambodo]

Hahaha... thank you Andrew, I finally manage to remove the annoying button from my worksheet