Excel, Macros won't run

Scripting Forums AppleScript | Mac OS X
,
#1

In Excel, I have a macro to find the last cell with data (LC) and a macro to set the conditional formatting of a range of cells (CF). In the Excel preferences, I have deselected “Macro virus protection” under the General tab. When I run the macros manually, they work. When I run my script, the script does not execute the macros and it does not provide and error. What am I doing wrong?

tell application “Microsoft Excel”
Activate
Evaluate “‘Personal Macro Workbook’!LC()”
end tell

#2

Try re-do your macro again. Delete the old one and build the new one, give it a new name. Your AS code should work fine.

-T