Remove password on 'file save as'
 

Hi,

I have a user workbook that I would like to password protect in order
to prevent inadvertent changes to the master copy.

Is it possible, to remove the workbook password protection when a user
performs the Save As function?

Thanks~


--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152948

Microsoft Office Help

Remove password on 'file save as'
 

Trixie;554681 Wrote:
Hi,

I have a user workbook that I would like to password protect in order
to prevent inadvertent changes to the master copy.

Is it possible, to remove the workbook password protection when a user
performs the Save As function?

Thanks~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!


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152948

Microsoft Office Help

Remove password on 'file save as'
 

Any excel solution would depend on macros and macros could be disabled.

If you want to be absolutely sure that users can't change the workbook, talk to
your IT staff to see if you can get a share that only you (and a few trusted
co-workers) have write access. The users should still have readonly access.

If you want an easy (but not 100% safe technique), mark your file as readonly
(using windows explorer).

Excel will respect that setting and your users won't be able to overwrite that
file.

On the other hand, you'll have to go through some more stuff to update it.

I'd copy real file to a private location (with a new name), update that private
copy (as long as that took).

Then I'd copy this file to the shared location (as a new name). And mark it
readonly.

I'd delete the original, rename the new file to the original's name.

But this only worked because most users didn't know how to go through that same
routine. It really won't stop anybody from doing the same thing.

(But how many people would want to!)

=====
On my private location, I'd use names like:

myWorkbook_2009_10_30_14_40_32.xls

And then I could move this final (ahem) version to a nice safe location. If
someone changed the file, I could use the latest saved version as the
replacement.

It also made "what was the price of xxxx on Sept 9th of 2008" easier to answer
(for example).




Trixie wrote:

Hi,

I have a user workbook that I would like to password protect in order
to prevent inadvertent changes to the master copy.

Is it possible, to remove the workbook password protection when a user
performs the Save As function?

Thanks~

--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152948

Microsoft Office Help

--

Dave Peterson

Remove password on 'file save as'
 

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!


--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152948

Microsoft Office Help

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!

[SOLVED]: Remove password on 'file save as'
 

Thanks Gord!

Always trying to make thing more difficult for myself~

I think that this will save me some grief...at least until someone
figures out how to re-save the template cgrin


Gord Dibben;558865 Wrote:
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!


--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152948

Microsoft Office Help