Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting file (modifying) with a slight twist
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting file (modifying) with a slight twist
Go to Tools | Protection | Protect workbook | check structure options
| ok On Sep 18, 6:20*am, Marc T wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting file (modifying) with a slight twist
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. "muddan madhu" wrote: Go to Tools | Protection | Protect workbook | check structure options | ok On Sep 18, 6:20 am, Marc T wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
password protecting cell in a protected file that are not protecte | Excel Worksheet Functions | |||
Gantt Charts with a Slight Twist | Charts and Charting in Excel | |||
Password Protecting an Excel file problem | Excel Discussion (Misc queries) | |||
Slight twist on dynamic ranges | Charts and Charting in Excel | |||
Password protecting certain worksheets in a file | Excel Discussion (Misc queries) |