Replacing a password protected file.
 

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?

Replacing a password protected file.
 

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


"JEV" wrote in message
...
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?