Macros in Excel 2003 are not recognized in 2007? 1

[kristal9]

Hi,

I am running Excel 2003 and created a spreadsheet for a colleague that contains a number of macros to import and format a large amount of data. She is running Excel 2007.

When she opens the workbook it does not give the normal prompt to enable macros. When she goes to run the macro it give the error that "the macro does not exist or is not enabled"

Is this simply a version thing? Is there any way around it? Any suggestion would be welcome.
Thanks! Kristal

 

[AnotherHiggins]

-> Is this simply a version thing?
Yes.

She needs to check her Macro Security level (Developer > Macro Security).

If the Developer Ribbon isn't visible, you'll want to enable it in Office Button > Excel Options (at the bottom) > Popular > Show Developer tab in the Ribbon).

Once she gets the macros enabled, she will almost surely get an error about missing references. This is because you have references to Excel 11 (2003). You'll (or she'll) need to go into the VBE to Tools > References and deselect those references, replacing them with the associated Excel 12 references.

After all of that is taken care of, your macros will probably work unless you use Application.FileSearch, which is no longer supported in 2007.

Converting from Office 2003 to 2007 is fun!!

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[AnotherHiggins]

Sorry - been away for a few days....

I should also mention that you can change Macro Security levels without turning on the Developer Ribbon by going to
[tab]Office Button > Excel Options > Trust Center > Trust Center Settings > Macro Settings.

And - this is really handy - you can set up a particular folder to be considered 'safe' so that no file opened from that folder will ever invoke the security notice about enabling macros. You can do that in
[tab]Office Button > Excel Options > Trust Center > Trust Center Settings > Trusted Locations.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.