Replacing a password protected file.

[JEV]

Is it correct that I can save over a password protected file (password
needed to modify or open) with a file with the same name? What am I missing.
Is there a way to avoid this?

 

[Bernie Deitrick]

JEV,

You need to mark the file as Read Only, either through Windows Explorer (right click etc.), or
through code (with the file closed)

SetAttr "C:\Path\File to be read only.xls", vbReadOnly

HTH,
Bernie
MS Excel MVP