Excel 2003 Error: You cannot save to this file format when the VBA project is protected.

[John Pullen]

Error message when saving.

You cannot save to this file format when the VBA project is protected.
You may unprotect the VBA project by choosing the Properties command on the
Visual Basic Editor's Tools menu, and entering the password for the active
project.

What the heck is this? I can't protect a VBA project in a .xls file any
more?

 

[Tom Ogilvy]

Look in Tools=>Options=>Transition tab and see what your default file format
is.

I suspect you are trying to save in something other than Microsoft Excel
Workbook.

 

[John Pullen]

You're correct. Thanks very much.

Rather confusing that the "Microsoft Excel 97 - Excel 2003 & 5.0/95
Workbook" format couldn't handle that. Oh well.