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

 

[Andrew Poulsom]

If you right click the button do you get a menu?

 

[Grapez]

Hi, I had a similar issue because when they installed my Excel 2007 my macros didn't work either. It appeared that you have to specifically select the install of VBA during installation. You can find it in the "office shared components" section during install.

 

[occam]

If you right click the button do you get a menu?

No, no menu on right click. occam

 

[occam]

Hi, I had a similar issue because when they installed my Excel 2007 my macros didn't work either. It appeared that you have to specifically select the install of VBA during installation. You can find it in the "office shared components" section during install.

What are the options to look for. (I am not familiar with VBA.) And can VBA be downloaded and installed retrospectively from an MS site?

 

[Andrew Poulsom]

Right click any Toolbar and choose Control Toolbox. Click the Design icon top left then right click the button. Do you see a menu?

 

[occam]

Right click any Toolbar and choose Control Toolbox. Click the Design icon top left then right click the button. Do you see a menu?

Thanks Andrew - when I right click on the toolbar, I get two options "Customize Quick Access Toolbar" and "Show Quick Access Toolbar below the ribbon". I do not see "Control Toolbox". occam

 

[Andrew Poulsom]

Silly me. In Excel 2007 the Control Toolbox is on the Developer tab. If you don't see that tab, it's Office Button|Excel Options|Popular|Show Developer tab in the Ribbon.

 

[occam]

Silly me. In Excel 2007 the Control Toolbox is on the Developer tab. If you don't see that tab, it's Office Button|Excel Options|Popular|Show Developer tab in the Ribbon.

OK, under the Developer tab there are 4 sub-menus: Code; Controls; XML; Modify. I've tried to 'View Code' (the offending macro is called 'fNewParticipant' - which should allow me to add a new participant to the form) but this is password protected by the designer I presume.

 

[Andrew Poulsom]

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