Something to try:

Set the excel macro security to medium or high.
Create a new spreadsheet.
record a simply macro (eg start recording, just enter some date in cells, stop recording)
save it as book1.xls and close excel.

then make a .vbs file with this next bit in it:
 Set AppXcell = CreateObject("Excel.Application")
AppXcell.Visible = True
Set filenm=CreateObject("Scripting.FileSystemObject").Getfile("Book1.xls")
AppXcell.Workbooks.Open (filenm)

now open the book1.xls - youll get a prompt about the macro security. so do whatever and close excel. this is normal.

now open run the vbs. the xls file opens and you can go to macros and run the macro with no security message box!?

why does this happen?

i've tested only in excel 2002 and 2003 (xp sp2). does this happen in the latest excel?