Excel 2007 Can't Save File with VB Script but it can in 97/2003format???

  • Thread starter Thread starter f252863
  • Start date Start date
F

f252863

"This workbook contains one of more of the following features that are
not supported by the selected file format:
- Script Objects"

If I save as a regular Excel 2007 file it is macro free (why?). If I
save as an Excel macro enabled workbook I get the message above. If I
save as the old 97/2003 format it can run macros and scripts.

Anyone know why the newer version can't support macros and scripts?

Thanks!
 
Thanks,

I'm saving as 4.xlsm, I'll try xlsx. I did check one of my scripts
and it still works so I don't know what it means by script objects.
 
Back
Top