Problem saving with VBA project protected.
 

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.

Problem saving with VBA project protected.
 

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




"JAMES T." wrote in message
oups.com...
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.

Problem saving with VBA project protected.
 

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." wrote:

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.

--

Dave Peterson

Problem saving with VBA project protected.
 

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

Problem saving with VBA project protected.
 

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." wrote:

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

--

Dave Peterson

Problem saving with VBA project protected.
 

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.

Problem saving with VBA project protected.
 

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.


"JAMES T." wrote:

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