Remove password on 'file save as'
Trixie
Why don't you save your Master as a Template(*.xlt or xltx)?
When users open the Master, they will get a copy of Master named Master1 to
work on.
They then have to save as a new name like Master1.xls
Master template never gets changed except by yourself.
No passwords needed on the Master template.
One problem is if they try to save as Master1 and Master1 already exists,
they will get a "do you want to overwrite" message.
If they click "Yes" then Master1 is overwritten and someone else's work is
gone.
At least your Master template can't get overwritten.
Gord Dibben MS Excel MVP
On Sat, 14 Nov 2009 19:37:29 +0000, Trixie
wrote:
Hi Simon,
Currently, the workbook opens with a dialog box asking if the user
wants to open as read only, options = Yes, No, Cancel.
95% of the time the users will select No and then save a copy to their
files to use.
Giving them the benefit of the doubt the other 5% of the time, I'll say
they just get click happy and select Yes without really thinking about
it, which results in me having to continually restore a Master Copy.
What I am looking for is either a way to force them to save a copy
prior to using the workbook.
- Either password protect to modify, removing the protection when the
user performs a Save As...this would be my choice, as I do have to
make modifications on occasion.
- Or, find a way to have the workbook open as Read Only (no dialog
box), but allow that restriction to be removed on Save As
Thanks~
Simon Lloyd;554865 Wrote:
Which do you have protected?
- Password to open workbook
- Password to modify
- Both the above
- Password protected worksheet
- Protected workbook structure
Some of these can be changed some cannot!
|