View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David Adamson[_4_] David Adamson[_4_] is offline
external usenet poster
 
Posts: 61
Default 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.