Locking VBA code via Project properties but cannot save the workbook over itself
From memory you can't save back down to 95.
As there was a lot of new coding stuff added in 97 that isn't compaitable
with 95.
This would be your problem. Try "save as" a Offcice 95 version and see the
message
"Shane" wrote in message
...
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.
|