Password protecting file (modifying) with a slight twist

  • Thread starter Thread starter Marc T
  • Start date Start date
M

Marc T

Hi all,

I've used 'Save As' > 'Tools' > 'General Options' and set a password to
modify. ONe slight issue that I have is that someone can open the file
read-only, then 'Save As' another filename and the password protection
disappears. Maybe there's another way?

Here's a little background: I have a master file that has the password
protection, and from this other copies are made for seperate projects. I need
each of these to also have the password protection as only a few people need
write access.... this isn't a problem if the file is copied/pasted via the
folder itself, but using 'Save As' gets around this.

Cheers for any help!
Marc
 
Hi,

thanks for the reply. I've just tried this but I'm afraid it doesn't work.
The password protection still disappears when saved as a new filename.
 

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

Replacing a password protected file. 1
Protect "Copy" and "Save As" changes to workbook 3
Password Protect so can't save and change 1
Password Protecting a workbook 2
failure to password protect file 4
File Protection with Save as & Copy option disable 4
XL2000 - Password to Modify Problem 2
Password Protected Files 3

Back
Top