Problem saving with VBA project protected.

  • Thread starter Thread starter JAMES T.
  • Start date Start date
J

JAMES T.

I have an application in EXCEL 2003 which uses VBA. I have password
protected the VBA project but when I try to save it I get the following
message:

"Cannot save in this file format while VBA project is protected"

I have other applications which I have protected and do not have this
problem.

Hopefully you can help me find the answer.
 
What is the format you use when you're trying to save the workbook?

Manually, it's at the bottom of the File|SaveAs dialog.

(It's not HTML stuff is it?)
 
xl95 didn't have the abilility to protect the project.

Is there a real reason you don't just use the "Microsoft Office Excel Workbook
(*.xls)"?

Xl97 through xl2003 will be able to read this file format.
 
My work computer is soon to be upgraded to MS Excel 2003. I will just
have to wait for the upgrade to protect the VBA. Thanks for your help.
 
If you're work computer is running xl95, then ignore this.

But if you're running xl97 (or greater) on all your pcs, then you can just save
in the most current version.
 
Back
Top