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

Excel VBA Project Has Protection? 2
Is project protecting VBA code secure - which alternatives are there 2
Cannot view code in VBE of a file with no password protection 3
Excel buttons change macro file name when run on other computers 7
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Protecting a VBA project 3
Why is my empty Excel workbook 2/3 MB in size? 5
VBA problem on Fresh Access 2007 Installation 3

Top