Ahhh. 5.0/95 didn't have protected projects. And excel is smart enough to stop
users from simply saving in xl95 to see your top secret code.

Do you really need xl95 format?

That's pretty darn old. I'm kind of surprised that nothing else broke!



Shane wrote:

Hi

It is just a simple macro ..

Im saving as file type - Excel 97 - Excel 2003 & 5.0 / 95 format. When the
file reaches the stage where its saving in 5/95 format it displays a message
that it cannot save the workbook with the VBA project being protected. Very
weird indeed. I am running Excel 2003. This is consistent behaviour with all
my files and other users are reporting the same issue.

"Dave Peterson" wrote in message
...
This isn't usual behavior.

You should be able to save your workbook with the project protected with
no
prompts.

Any chance you have a misbehaving macro that causes an error message to
appear?

Shane wrote:

Hi All, is there a way you can lock your VBA code via the VBA project
properties but also have the user save the workbook without being
promted to
unlock the VBA project?? I have locked my code but connot save the
workbook
without unlocking my VBA code.

Thanks
SK

--

Dave Peterson


--

Dave Peterson