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

  • Thread starter Thread starter John Pullen
  • Start date Start date
J

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?
 
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.
 
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.
 
Back
Top