Problem saving with VBA project protected.

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

 

[Anne Troy]

Unprotect the VBA. Hit File-Save as. What does the files of type say? If it
looks okay, better go to Tools-Options, Transition tab and check out what
type of file it's being saved as.


****************
Anne Troy
www.piersontech.com
www.mrexcel.com

 

[Dave Peterson]

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

 

[JAMES T.]

The format under "save as" is "Microsoft Excel 97 - Excel 2003 & 50/95
workbook".

 

[Dave Peterson]

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.

 

[JAMES T.]

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.

 

[Dave Peterson]

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.