Replacing a password protected file.

J

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?
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Are password protected WiFi networks secure? 3
Link to a password protected file 1
Password Protected Files 3
Protect "Copy" and "Save As" changes to workbook 3
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Password protected and shared workbook 1
Password protected worksheet 2
Opening a password-protected spreadsheet from a website link 1

Top