Remove password on 'file save as'

[Trixie]

Hi,

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

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

Thanks

 

[Simon Lloyd]

Hi

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

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

Thanks~Which do you have protected

- Password to open workboo
- Password to modif
- Both the abov
- Password protected workshee
- Protected workbook structur
Some of these can be changed some cannot

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Dave Peterson]

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).

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/showthread.php?t=152948

Microsoft Office Help

 

[Trixie]

Hi Simon,

Currently, the workbook opens with a dialog box asking if the use
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 thei
files to use.
Giving them the benefit of the doubt the other 5% of the time, I'll sa
they just get click happy and select Yes without really thinking abou
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 cop
prior to using the workbook.

- Either password protect to modify, removing the protection when th
user performs a Save As...this would be my choice, as I do have t
make modifications on occasion.
- Or, find a way to have the workbook open as Read Only (no dialo
box), but allow that restriction to be removed on Save As


Thanks~

Which do you have protected?

- Password to open workbook
- Password to modify
- Both the above
- Password protected worksheet
- Protected workbook structure

 

[Gord Dibben]

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

 

[Trixie]

Thanks Gord!

Always trying to make thing more difficult for myself~

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