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

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?
 
T

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

you cannot save to this file format when the VBA project is protected 7
Macro to lock VBA project 2
Saving workbook with protected (hidden) VBA code 1
Excel VBA Project Has Protection? 2
Excel cannot find or read file 5
VBA for XL97 1
Saving a spreadsheet with a protected VBA project 1
Saving Protected Workbooks 3

Top