Macros error

[lfb21]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hi There, I have an apple mac G5 with mac os 10.5 Leopard.

I have Office 2008 installed, and I keep getting an error in Excel, it has happened recently as the document worked before and I have never gotten this error.

When I open this specific document I get an error explaining that the document contains Macro's and I can either open and remove macros or open. If i choose open, the document opens and it looks fine, once i click on a "button" i have on the document that works on a calculation, it then comes up with the error " Cannot run the macro "document name" Macro5! cannot be found"

Any ideas why this is happening?

 

[Jim Gordon Mac MVP]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hi There, I have
an apple mac G5 with mac os 10.5 Leopard.

I have Office 2008 installed, and I keep getting an error in Excel, it
has happened recently as the document worked before and I have never
gotten this error.

When I open this specific document I get an error explaining that the
document contains Macro's and I can either open and remove macros or
open. If i choose open, the document opens and it looks fine, once i
click on a "button" i have on the document that works on a calculation,
it then comes up with the error " Cannot run the macro "document name"
Macro5! cannot be found"

Any ideas why this is happening?

Hi,

Excel 2008 does not support macros. If they are in the workbook, they
are retained as long as you don't choose to remove them. However, no
macros will work.

Use Excel 2004, or wait until Excel 2011 goes on the market later this
year. Both of those versions do support macros.

-Jim

 

[lfb21]

Hi Jim

The problem here is the document was working fine in Excel 2008 for the past two months and I have had no problems or errors with macros before last week.

The only thing that did change is the fact that I ran an update last week, but there were no updates specifically for Office itself.

If there is an option to turn the macros off, then how is there no option to turn them on?

 

[Jim Gordon Mac MVP]

Hi Jim

The problem here is the document was working fine in Excel 2008 for the
past two months and I have had no problems or errors with macros before
last week.

The only thing that did change is the fact that I ran an update last
week, but there were no updates specifically for Office itself.

If there is an option to turn the macros off, then how is there no
option to turn them on?

Hi,

There is an older style of Macros called XLM macro language. Those
macros are supported in Excel 2008. There is a new update for Office
this week (use Help > Check for Updates), but I am not aware that any
updates are breaking XLM macros. However, stranger things have happened.
Maybe someone else will chime in.

-Jim